This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to extract text and numeric patterns from a string. The strings are in the format of Account names, numbers, and some numbers.
1. Account Name 1 123456 10.256
2. Account & Na@me 2789 11\\456
3. Ac_NT N123ame 351462 12/453
The problem I’m facing is that the account name can have numbers within it, alpha/special characters/spaces within it.
When I write a pattern to extract the name, it greedily parses the spaces after the name and the account numbers after it. The only pattern I distinctly see in the data is that there is at least 3 spaces after the account name and before the account number.
So a pattern that catches everything before 3 spaces and then 3 or more digits after the spaces is what I’m looking for.
Would be great if someone can take a shot at this!