Goal - Extract numeric part and alpha part from a string as below
Input:
| Source |
| ATUL1234 |
| SINGH374 |
| I23S |
| C343LEAR |
Output -
| Source | Part1 | Part2 |
| ATUL1234 | ATUL | 1234 |
| SINGH374 | SINGH | 374 |
| I23S | IS | 23 |
| C343LEAR | CLEAR | 343 |
Like the below page to get update
My scrapbook about anything which I learned or want to remember, Sometime about tech tips, thoughts and rambling. If you find anything useful don't forget to give thumbs-up :)
| Source |
| ATUL1234 |
| SINGH374 |
| I23S |
| C343LEAR |
| Source | Part1 | Part2 |
| ATUL1234 | ATUL | 1234 |
| SINGH374 | SINGH | 374 |
| I23S | IS | 23 |
| C343LEAR | CLEAR | 343 |
About Atul Singh
I am a Data Consultant at a Canadian financial firm. My keen interests varies from Data Analytics, ML, Kubernetes, NLP to ETL.
I love to blog and travel in my spare time. If you’d like to get in touch, feel free to say hello through any of the social links.
No comments:
Post a Comment