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
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.
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.
User | Count |
---|---|
107 | |
82 | |
69 | |
54 | |
40 |