Regex parse

[FECL3]

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

[atcodedog05 · Accepted 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 😀👍

[PhilipMannering]

@atcodedog05 Pretty sure that your regex will leave lots of trailing spaces

[atcodedog05]

@PhilipMannering 

My first step was to use data cleansing tool to remove duplicate, leading and trailing space 

hence it should be able to handle it 😅

[FECL3]

Thank you - works a treat!

[atcodedog05]

Happy to help 🙂 @FECL3 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[FECL3]

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

[atcodedog05]

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 🙂