Substring applied on the values in the column or columns. Indexing from one. The settings are:
Which column to edit:
Starting index of substring (inclusive): This is 0 indexed meaning the first character in your string is character 0.
Ending index of substring (exclusive) (optional): This is also 0 indexed, meaning if you wanted to remove everything after the 5th character you would enter “6” here as the 6th character onward will be removed.
Use regular expression (optional): If this box is checked you can use regex to define the starting and ending indexes of the columns identified.
