RegEx help

Looking for some help with RegEx as I do not use this very often. I could use the Parse tool but hoping to learn a bit more about RegEx. I am looking to take a string that has underscores and also varies in length. I am looking to exclude the far right of the string for each entry to include the last underscore. Any help appreciated.

Examples

123_12345_12345678910

12345_123456_12345678910

12_123456789_12345678910

Result

123_12345

12345_123456

12_123456789

Developer Tools

Regex

Tips and Tricks

Parse

Accepted answers

Yoshiro_Fujimori

Hi @cstafford ,

Here is a sample formula to output your expected result. I hope this helps.

Formula

Result = REGEX_Replace([Examples], "(.+_.+)_.*", "$1")

Output

Examples	Result
123_12345_12345678910	123_12345
12345_123456_12345678910	12345_123456
12_123456789_12345678910	12_123456789

RegExExample.yxmd

All comments

alexnajm

Try (.+)_.+

This is saying, with the parentheses, to give you one or more characters before the last underscore, and ignore the underscore and anything afterwards.