Extracting data from substring

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.

Accepted answers

Emil_Kos

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!

Substring 2.yxmd

atcodedog05

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

extract.yxmd

All comments

Emil_Kos

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!

Substring 2.yxmd

atcodedog05

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

extract.yxmd

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 😀

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335