Hi Team,
I have a column of data in a text like
Column name:
abcde;def;567;name1:bk;name2:bh
I would want to take out values name 1 as a column with value as bk and name 2 as a column with value as bh
the column has a lot of bad data as well.
what is the best way to achieve this
@SouravKayal you're essentially looking to get the data in the correct form to cross-tab. You may need to add another step to this in your data, making a tag to group on in the crosstab to stop concatenation.
Edit: Also realised I missed that it looks like you might be talking about a column name. If so then Finn's solution below is perfect
@SouravKayal , have realised this is a column name? You can put this into a field with the multi-field tool, and then do the same:
dint work for me , may be i gave the incorrect format so the input data is like
number: 123; Rate: 3; Status:XYZ; Type: FULL; Owner: TOM; Owner2: BOB
@SouravKayal Finn's answer isn't catching it because there's a space in your real data after the : which would need to be reflected in the RegEx. Mine is looking for the word name instead of Owner. Both should be fairly easy fixes depending on what you're looking for.
Seems like you don't even need the regex tool if you want to keep all of the name:value pairs. Try this:
Thank you i could make some changes and make this work now if i have multiple columns to parse in the same data set should i just create more of these flows