How to split string text and numbers into different columns

[dunkindonut7777]

Hi I have a data here that shows the combination of string and numbers. I want to separate or split the two different characters into different column:

Input

122220 Property Equipment

122330 Office- Equipment

Expected Output1	Expected Output2
122220	Property Equipment
122330	Office- Equipment

Can you help me resolve this one pls? Thank you

[DenisZ]

Please find the updated workflow. 

Please mark as solution if this solves your issue. 

[grazitti_sapna]

Hi @dunkindonut7777 , Please use the below configuration to get your desired output. In the below regex expression it will handle any number of spaces in between your digits and string.

[ShankerV]

Hi @dunkindonut7777 

Hope your issue is resolved. Kindly let me know if anything is blocking.

Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Shanker V

[Kiran1210]

Hi All

My data is really tricky. I am looking for numbers in different columns after removing any additional text or special character in between. A  line could have more than 3 ids, so generate column accordingly

Can someone please help

Attached file

[Kiran1210]

Hi All

Can someone please help with my query

[fdiazlemus]

@dunkindonut7777 Do you know where I can find a list of commands for the regex tool? You posted \d* , \s , .*, which was really helpful.