Regex

[Alteryx_user_123456]

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!

[nagakavyasri]

@Alteryx_user_123456 

[flying008 · Accepted solution]

Hi, @Alteryx_user_123456 

FYI.

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

2- By use formula of regex:

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

[grazitti_sapna]

Hi @Alteryx_user_123456 

I have made Workflow for your Problem. Please Check.

If it works Kindly accept it as Solution.

Thanks

[Alteryx_user_123456]

Thank you, this worked well!