For example, if parsing a column containing the data “ 10_5N_1 ”, with the specified Prefix of “ New ”, and with the specified Delimiter “ _ ”:
• Parsing from the left results in the following new columns: New_1 containing “ 10 ”, New_2 containing “ 5N ”, and New_3 containing “ 1 ”.
• Parsing from the right results in the following new columns: New_1 containing “ 1 ”, New_2 containing “ 5N ”, and New_3 containing “ 10 ”.