Regex

Hi All,

I'm trying to create a Regex that will pick out only required information from a text string. Running into trouble setting it up, appreciate any help from the community.

Below are some sample texts to parse, essentially I want to extract just the "CON-1234567" information in a separate column.

CON-1234567 abc testing site

con-1234567 abc testing site

abc testing site CON-1234567

abc testing CON-1234567 site

CON-1234567_abc testing site

Thanks in advance!

Regex

Parse

Accepted answers

flying008

Hi, @Alteryx_user_123456

FYI.

(?:^|\s)(\w+-\d+)(?=\s|_|$)

录制_2024_01_12_13_32_48_424.gif

2- By use formula of regex:

REGEX_Replace([Txt], '^[[:alpha:]\s]*?(\w+-\d+)[\s_]*?.*$', '$1')

录制_2024_01_12_13_47_39_455.gif

All comments

Hi, @Alteryx_user_123456

FYI.

(?:^|\s)(\w+-\d+)(?=\s|_|$)

录制_2024_01_12_13_32_48_424.gif

2- By use formula of regex:

REGEX_Replace([Txt], '^[[:alpha:]\s]*?(\w+-\d+)[\s_]*?.*$', '$1')

录制_2024_01_12_13_47_39_455.gif

grazitti_sapna

Hi @Alteryx_user_123456

I have made Workflow for your Problem. Please Check.

If it works Kindly accept it as Solution.

Thanks

Regex solution.yxzp

image (15).png

Alteryx_user_123456

Thank you, this worked well!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703