RegEx Parse and Text to Columns a String of Text

[YLYONG]

Hi Alteryx Community,

I'm wondering if there's a way to parse the below string of text? 

Thank you

 

[atcodedog05]

Hi @YLYONG 

You can try configuring text to column like this.

Can you provide sample data in excel so that we get more calrity?

Hope this helps : )

[YLYONG]

@atcodedog05 how do I upload a file?

[atcodedog05]

Hi @YLYONG 

You will get an option like below in the comment box to add file.

[YLYONG]

@atcodedog05 

[atcodedog05]

Hi @YLYONG 

You can achieve this by either using text to column or regex tool parse method.

Workflow:

Hope this helps : )

[YLYONG]

@atcodedog05  Thank you for your input and help

Which "regular expression" did you choose? I am not able to reference these codes with any of the option in the drop down list.

[atcodedog05 · Accepted solution]

Hi @YLYONG 

Here is the breakdown of the regex

(  start of 1st group that needs to be extracted

\d+ one or more numbers

)  end of 1st group that needs to be extracted

\s space

(  start of 2nd group that needs to be extracted

.+ one or more any characters

)  end of 2nd group that needs to be extracted

This resource is helpful on the above topic:

https://community.alteryx.com/t5/Interactive-Lessons/Parsing-Data-with-RegEx/ta-p/441415

Hope this helps : )