TRANSFORMER
SUBSTRING
SUBSTRING is a calculator function that gets a substring of a string.
Choose a field that is to contain the result in the Result Field drop-down list at the top, or create one by entering a new name.
Syntax
SUBSTRING(<text>,<start>,<end>)
where <text> is a field containing a string, <start> is the first position, and <end> is the position directly following the last one you want to find.
Use
Use SUBSTRING to get part of a text string, e.g. to only use the first part of a longer text.
The first character in a string always has position "0", so to get the first three characters in a column called "name" write: SUBSTRING(${name},0,3)
