Query on Data cleansing / Blending

[Khanzali007]

I have query, kindly refer attached data & refer column G for text input.

In this column i would like to get output of 10 digit numeric number which starts from 90 & length is 10. This invoice no will be any part of the text it may be at left, right & even in mid of the data. Kindly help how to extract this invoices in new column & ignore rest raw data.

Example are explained below with input & output required, & output is highlighted in red text in input.

For Eg 1:  

Input = Sales recon 5310 -ref-9019090387  

Output -  9019090387

For Eg 2:  

Input = 9019207882 - Tesla  

Output -  9019207882

For Eg 3: 

Input = 40266945 yment-UTR-PUNBH19096855078-RAIC  

Output -  9096855078

For Eg 4: 

Input = 39001540211000  

Output -  9001540211

[FlorianC · Accepted solution]

Hi @Khanzali007,

You can leverage regular expressions for this specific purpose. It is a very powerful way to quickly identify a pattern in large amounts of data.

Please find attached a sample workflow showing how to do it.

Workflow

[Khanzali007]

Thanks you so much for your quick response. @florianC