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
Solved! Go to Solution.
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
My first step was to use data cleansing tool to remove duplicate, leading and trailing space
hence it should be able to handle it 😅
Thank you - works a treat!
If one of the lines was a negative number where the digits would typically be - how would I adapt the regex parse. Thanks in advance
Hi @FECL3
I have modified the regex to handle it.
(.*)\s(-?\d*)
I modified the current data to have negative number.
Output:
Hope this helps 🙂