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 |
Solved! Go to 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 😀👍
Both solutions worked perfectly fine. Thank you for the help.