Substring

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.