Extracting data from substring

[SCK]

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.

[Emil_Kos · Accepted 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!

[atcodedog05 · Accepted solution]

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 😀👍

[SCK]

Both worked perfectly well. Thank you for the help. 🙂 🙂

[Emil_Kos]

Hi @SCK,

Thank you for marking my post as a solution!

Good luck!

[atcodedog05]

Happy to help 🙂 @SCK 

Cheers and Happy Analyzing 😀