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 · Accepted solution]

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

[k3pineapple]

@Yoshiro_Fujimori Great ！！！Exact the answer !!!

I just realized that this could be done as well in your flow.

what i can change to get answer like this? thank you

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
5	GOE	Pear	zxcvbnm
6	GOE	Pear	hjklgfd
7	AAA	Pear	aaaaaaa

[Yoshiro_Fujimori · Accepted solution]

@k3pineapple ,

Yes, actually the data is already prepared after the 2nd Formula tool.

Some steps are added to sort and re-number the ID.

Workflow

Output