Hi All. I need help from extracting only numeric values from the beginning of a substring, if any. My input and desired output looks like this:
Input:
Account |
1000 cash |
2000 AR |
Trade receivable |
Trade Payable |
5000 Suspense |
6000 COGS |
Desired Output
Account1 | Account2 |
1000 | cash |
2000 | AR |
Trade receivable | |
Trade Payable | |
5000 | Suspense |
6000 | COGS |
Please help.
Solved! Go to Solution.
Hi @SCK,
I am not regex specialist but it looks like this could be achieved with data cleansing tool:
Output:
If this was something helpful please mark as a solution!
Good luck!
Hi @SCK
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Both worked perfectly well. Thank you for the help. 🙂 🙂