Keep all characters to the left of a special character

[cstafford]

looking for a way to keep all characters to the left of a special character and the character length will vary. I assume I RegEx would work but I am not very savvy with writing the correct formula.

Example

TEST_SAMPLE_1234   create a new column with TEST as the result

TRYTHIS_SAMPLE_12345  create a new column with TRYTHIS as the result.

[DavidSkaife · Accepted solution]

Hi @cstafford 

Assuming your first word will always be alpha only, and capitalised, a simple Regex Parse like below will work. There are alternatives if it's lowercase etc:

An alternative method is to use Text to Columns tool, with _ as the delimiter, split to two columns and then use a Select Tool to drop the extra:

Workflow with examples attached

[RobertOdera · Accepted solution]

Hi, @cstafford 

Below are some methods for you to consider.

Please mark it as a solution if it works for you - cheers!

[RobertOdera]

You're very welcome @cstafford!