Need help in extracting only true accounts

[SCK]

Hi all. I have a V string data that contains account numbers in numeric and alphanumeric form as well as some other details. I need to extract only true accounts. I have attached the input and desired output. Please help.

[JosephSerpis · Accepted solution]

Hi @SCK I mocked up a workflow that produces the output you describe. Let me know what you think?

[atcodedog05 · Accepted solution]

Hi @SCK ,

As per the requirement you want to extract records which has numeric elements.

Here is how to do. Use below pattern in Regex tool in Match config.

.*\d.*

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind😀👍

[SCK]

Both worked perfectly fine. Specially @JosephSerpis because it did not restrict to elims only. Thank you so much for your help. Really appreciate both of you..

[atcodedog05]

Hi @SCK 

If our solutions helped can please mark them as solutions🙂

Happy to help🙂

[atcodedog05]

Thank you

Happy to help 🙂 @SCK 

Cheers and Happy Analyzing 😀

[SCK]

Thank you again 🙂