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.

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.

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.