SUBSTR Function is used to extract a portion of the string.
SUBSTR(string Input,int Start,[int Length])
Example : Remove First Two Characters
In the above example, Informatica Returns the positions itself at 3rd character and returns the rest of the string. In Informatica, Start of the string is 1 and not 0
Example : Extract Third and Fourth Character
In the above example 2 characters are returned, starting from the 3rd character.
Substring can also be used to extract last few characters of the string. The below example shows how to extract last 3 characters from the string.