Split value in one cell into muti-rows

Question

Hi All,

I am stuck on a data cleansing progress flow.

Need your help to build a flow to split the value in one cell, every cell has dirty value need to be reformatting. Thx

Input

IDNameAccount1Account21ABC12345{12345}2CDE34567{123 456 78} {34567}3FGH78901{789 01 237^78901}4IJK23456234565LMN345 678 90{345 678 90}

Output

IDNameAccount1Account21ABC12345123452CDE34567123 456 782CDE34567345673FGH78901789 01 237^789014IJK23456234565LMN345 678 90345 678 90

FinnCharlton · Accepted Answer

Hi @k3pineapple , you can do this with the RegEx tokenise tool, and clean the data with a RegEx Replace function:

The RegEx expression looks intimidating, but it is just telling the tool to split anything within { } onto a new line, also accounting for digits not it { }.

flying008 · Accepted Answer

Hi, @k3pineapple

Maybe you can use RegEx tool by Tokenize method:

Spoiler

([\d\s\^]+)(?>\}|$)