Forum Discussion

m00ch's avatar
m00ch
Regular Visitor
1 year ago
Solved

Extracting a number string after a two character delimiter

Hello everyone,  Could someone help me create an efficient way to extract an alphanumeric string that varies in length but always comes after the first "T#"? There may be a whole bunch of garbage be...
Need Help
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    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!

v-karpurapud's avatar
v-karpurapud
Community Support
1 year ago

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!

v-karpurapud's avatar
v-karpurapud
Community Support
1 year ago

Hello m00ch 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.