Query on Data cleansing / Blending
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Strategic Solution Consultant
Alteryx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks you so much for your quick response. @florianC
