Remove everything after second_

[craigja]

Hi,

Can one of yo experts give me a way to remove everything after the 2nd _ in the following?

DER_FEX_HEDG

DER_FEX_INVH

DER_FEX_GEHR

So for the first row I want DER_FEX

[mpennington · Accepted solution]

This should work for you: 

REGEX_Replace([Info], '(.*)_.*', '$1')

[messi007 · Accepted solution]

@craigja,

This will do the job for you as well:

Attached the workflow,

Hope this helps!

Regards,

[craigja]

Brilliant, this solves the problem nicely!