Parse out user id with RegEx

lahughes

I have a column of data that has first name, last name (user_id). It looks like:

lname, fname (c709979)

I want to parse out the user_id text into its own column, without the parenthesis.

Is RegEx the best way to do this or is there another tool I should use instead?

If RegEx, than what would the context look like?

Thanks,

Larry

Regex

Accepted answers

MarqueeCrew

@lahughes,

Create yourself a UserID field with the following formula:

REGEX_Replace([Field1], ".*\((\w+)\)", '$1')

Whatever is within the parenthesis will become the userid. Just change Field1 to your incoming data.

Cheers,

Mark

All comments

MarqueeCrew

@lahughes,

Create yourself a UserID field with the following formula:

REGEX_Replace([Field1], ".*\((\w+)\)", '$1')

Whatever is within the parenthesis will become the userid. Just change Field1 to your incoming data.

Cheers,

Mark

lahughes

Thank you Mark. That worked perfect. Appreciate the help.

I struggle with the proper syntax of the RegEx tool. I have used the online help and articles, and understand the overall idea, but when it come to writing the actual statement I can never get it to output what I want. I guess just more practice and time will help in me understanding the symbols and the structure to use.

Thanks,

Larry

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703