Remove characters from a string upto a special character

[aravindraj004]

I have a columns with varying string length like

1) 102_2345

2) 23_12357

3) 786_8790

I have to remove all characters up to "_"  and result should look like

1)2345

2)12357

3)8790

Help me out in this requirement

[mborriero]

Hi @aravindraj004, you can use a regex or a formula tool.

Have a look at the workflow attached.

[suli]

You can also use 'Text to columns' (from Parse category) tool, simply use '_' as a separator for 2 columns, and drop unnecessary column in the later steps.

Hope that helps!

[mborriero · Accepted solution]

Amended. I did not read up to _

I am still sleeping!

[aravindraj004]

Thanks mborriero.This worked perfectly