Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Find Number in Multiple Line Text String & Extract to Column

earthedice
5 - Atom

Hello, (Running Designer version Version: 2021.1.4.26400)

 

Been searching and trying to learn the Regex tool better, but struggling with this one. I need to find the member ID for each row contained in a column I will call Work_Notes. The dummy data is below as I see it, caveat being that the member IDs can be different lengths of numbers. I need the member ID in a separate column. The text below is all contained in one row or cell. Dummy member ID is bolded and there appears to be consistently 4 spaces after the colon before it, but not positive on that for all records.

 

 

2017-10-22 10:10:46 - System Administrator (Work notes)
Provider Details :

 

2017-10-22 10:10:46 - System Administrator (Work notes)
Provider Details :

 

Matched TAT rule!

 

CDI0507359 matched rule TSL0005063 - M&R ORS -Priority 3-Days 5
TAT Goal: 5 Days Member Details :    2931317250

 

2017-10-22 10:10:46 - System Administrator (Work notes)
Matched TAT rule!

 

CDI0507359 matched rule TSL0005063 - M&R ORS -Priority 3-Days 5
TAT Goal: 5 Days

 

 

2 REPLIES 2
Watermark
12 - Quasar
12 - Quasar

This needs more data. Regex is all about identifying a pattern and building the regex to recognize the pattern and leverage it to extract what you want.  Even if you gave just 10 rows of data, I could come up with something that would match it.  What you have above, you can't really build a pattern off of a set of data of 1 record. It'd be easy to match 'this' record, but no confidence that it'd match any more. 

earthedice
5 - Atom

Thanks for responding. This was a duplicate post as it was made over the weekend and bots would not let it post originally. The other thread I had provided the answers. 

 

To your point, each cell of data could be a different lengths and characters of text with the exception of the one line that contained the Member ID. This was solved. Please see attached screenshot.

 

 

Labels
Top Solution Authors