Function Name:
Lpad
Purpose:
The Lpad function pads the given input text with a specified string, to the left of the input text.
Configuration:
1. Enter a Display label for the node. This will be helpful with identifying the node when viewing your Entity Pipeline.
2. Enter a Description that will explain the criteria configured.
3. Pad With is where you will specify what character(s) are inserted to the left of the text value.
4. Pad to Size is where you will specify the maximum length of the new value generated by the Lpad function. For example, if you set the Pad to Size value as 5 and Pad With value as 0, the input value 123 will be updated to 00123.
Example:
You may need to normalize a postal code value where leading zeros have been stripped off. If the postal code from the source is 4019 and it really should be 04019, you could use the Lpad function to fill in the leading zeros into the postal code.
Configure the function with these values:
Pad With: 0
Pad to Size: 5
This configuration will convert 4019 to 04019. Any 5 digit postal code will process through this function and remain unchanged.