Split data

[SCK]

Hi all,

I need help in splitting the data. Below is the input and desired output. Please provide solution. Thanks in advance.

Input:

Account

10006 - Petty Cash - usable

10010 - Cash - Operating Account - Bank.

11000-11 - Accounts Receivable - Unit1

11000-12 - Accounts Receivable - Unit2

Output:

Account1	Account2
10006	Petty Cash - usable
10010	Cash - Operating Account - Bank.
11000-11	Accounts Receivable - Unit1
11000-12	Accounts Receivable - Unit2

[atcodedog05 · Accepted solution]

Hi @SCK 

Regex Tool | Parse mode

([\d-]+) - (.*)

Give this regex a try.

Output:

Config:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[PhilipMannering · Accepted solution]

Hi @SCK 

The regex tool can make short work of this. See attached.

[SCK]

Both solutions worked perfectly fine. Thank you for the help.

[atcodedog05]

Happy to help 🙂 @SCK 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂