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