How would I regex parse this data so I have two columns, one with the words and the other with the digits? They have uneven spaces between the characters too.
Please see attached
Hi @FECL3
The process would be to clear duplicate spaces with data cleasing tool.
And here is the regex config
Output:
Workflow:
Hope this helps 🙂 Hope this what you are looking for is not let me know i can help
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
@atcodedog05 Pretty sure that your regex will leave lots of trailing spaces
Thank you - works a treat!
