Split data

[SCK]

I know I just got a solution, however, I have another add on to the input. Please help.

Input:

Account

10006 - Petty Cash - usable

10010 - Cash - Operating Account - Bank.

11000-11 - Accounts Receivable - Unit1

11000-12 - Accounts Receivable - Unit2

100D - Prepaid

200CD - General Expense

Output:

Account1	Account2
10006	Petty Cash - usable
10010	Cash - Operating Account - Bank.
11000-11	Accounts Receivable - Unit1
11000-12	Accounts Receivable - Unit2
100D	Prepaid
200CD	General Expense

[atcodedog05]

Hi @SCK 

Is it only D or can it be anything?

[atcodedog05 · Accepted solution]

Hi @SCK 

Here is a regex 

Regex Tool | Parse mode

([\w-]*) - (.*)

Output:

Hope this helps 🙂

[PhilipMannering · Accepted solution]

@SCK 

I think you could just replace the \d with \w for both @atcodedog05 and my earlier solutions.

Let us know if it works.

P