Hi all,
I've tried going at this a few different ways with no luck. I am pretty raw yet with Regex and am hoping this current business need will spring my skillset further with some help from the Community here. I have also tried Text to Columns with no luck.
I need to parse out the Member ID in the dummy example string below into a separate column. Whatever method that can locate and extract it I am open to, whether it's via Regex or other methods. The Member ID can be different lengths, but there is consistency with the line it is contained in and the 4 spaces prior to the number after the line text, which is "TAT Goal: 5 Days Member Details : 2931317250"
Here is what the Comments field looks like and I have also attached a screenshot with the desired output. I have about 26,000 rows in my dataset. Any help on this would be appreciated immensely and I am not concerned about what happens to the original Comments field. *Cannot post the text here without the system picking it up as spam, so attaching via Notepad.
Solved! Go to Solution.
@atcodedog05 let me dummy something up. I have 2 scenarios. One where the Provider info is populated and one where it is not. Be right back.
@atcodedog05 First example below is how the text field appears in a cell and it has Provider Info. The second example does not have Provider info, so I'd want to return a blank for both PROVIDER_TIN and PROVIDER_NAME.
First example
Output columns should be:
PROVIDER_TIN
390908226
&
PROVIDER_NAME
BEST WESTERN HEALTH
Second example below:
Need to return blanks:
PROVIDER_TIN
&
PROVIDER_NAME
I am close with what I'm doing now using 2 separate Regex parse tools, but when the Provider info is blank, I am getting a result like --
PROVIDER_TIN .*Provider Details :\D+(\d+).*
1096148 (this is a truncated number below in the cell without the leading letters)
PROVIDER_NAME .*Provider Details :([^\d]+).*
Matched TAT rule!
Hi @RifferX
Can you please provide this sample data in excel so that will be easy for me to build a workflow with and help you out.
It probably might be escape newlines and it might work.
PROVIDER_TIN .*Provider Details :[^\n\d]*(\d*).*
PROVIDER_NAME .*Provider Details :([^\d\n]*).*
Hope this helps : )
@atcodedog05 Your solution appeared to work but I haven't tested it entirely yet. Sorry, I had a meeting,
Awesome🙂!! I hope you also understood how it works.
It's night here I will be logging off for the day. If any more questions, I would probably answer them tomorrow.
Hope this helps : )
Thanks @atcodedog05
I will wait on your response when you get a chance. Really appreciate your help with this as it was a deliverable today. Cheers!