Hi,
I want to split the following string field into 2 (by separating the number and words on the first instance only). See the following data:
4759-05-71 AB(CD)
1090-43-000-000Petty Cash:Admin
1990-43-000-000Petty Cash: Admin - #4201:2Admin
1077-00-00 HDK Concentration (Ending 3873)
As you can see there aren't any set structure to the string. But I would like the following:
Column 1 Column 2
4759-05-71 AB(CD)
1090-43-000-000 Petty Cash:Admin
1990-43-000-000 Petty Cash: Admin - #4201:2Admin
1077-00-00 HDK Concentration (Ending 3873)
Thank you so much for your help in advance.
Solved! Go to Solution.
Thank you. Your Regex formula works perfectly. What will be a good website that you recommend to learn regex expression? It's such a powerful tool.
@calvinwong, I am curious to know if you tried my solution-a length workflow though
Thank you for your help. I did look at your workflow and it did the work as well (just in a longer way). :)