Split Value in the Curly Brackets and Remove Curly Brackets

k3pineapple

Hi 

Currently, having a junk data need to be sort out. Kindly seeking your help.

Data Set

ID	Company	Product	Account
1	ABC	Apple	abcc nq
2	CDE	Banana	{abcdefg}
3	EDG	Banana	{cdn abc de}
4	GOE	Pear	{aaa bbb cc} {zxcvbnm} {hjklgfd}
5	AAA	Pear	aaaaaaa

Output

ID	Company	Product	Account	Account1	Account2
1	ABC	Apple	abcc nq
2	CDE	Banana	abcdefg
3	EDG	Banana	cdn abc de
4	GOE	Pear	aaa bbb cc	zxcvbnm	hjklgfd
5	AAA	Pear	aaaaaaa

Not sure how to use Reg tool in the case.

Looking forward your answer, Thank you very much

Yoshiro_Fujimori

Hi @k3pineapple ,

Here is one potential solution.

I struggled with the rows which does not match with the above RegEx (i.e. no brackets).

After all, I solved it outside of RegEx tool. It still works, but I know it is a little ugly.

It would be great if any smart user shows a RegEx which matches with these exceptional rows as well...

Workflow

RegEx tool configuration

RegEx_SplitBrackets.yxmd