Forum Discussion
Extracting a number string after a two character delimiter
Hi m00ch
To better understand the issue and provide an accurate solution, could you share a sample dataset in a .csv or Excel file? This will allow us to analyze the data structure and understand how the CR and LF characters are impacting the results. Please anonymize any sensitive information if necessary before sharing.
Thank you!
Hi m00ch, so it works. You wanted to extract "extract an alphanumeric string that varies in length but always comes after the first "T#""
dufoq3 I do appreciate your help and it seems that I wasn't clear enough. I should have said or displayed better that the CR and LF was in the same cell and that there was more data after the CR and LF. That is my fault. My initial screenshot was from one row in Power Query but I can see how it looks like separate rows.
I'll do better next time.
Hi m00ch
Hope you are doing well!May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Unfortunately no, it did not resolve my issue as I did not clearly state my issue in the first post.