Regex multi-field formula

[Anudeep_Yalamuru]

Hi

I have 5 columns in a file where certain columns have multiple fields concatenated. I want to segregate the fields with a , into two different fields.

Attached a sample screenshot. I understand i have to use multi-field formula. But not sure of what to write in expression.

Underlined columns in focus

Please suggest.

Thanks,

Anudeep

[CoG · Accepted solution]

I can modify the workflow some as needed based on some intuitions I have, but I wanted to get your feedback first. Here is a workflow that uses the Multi-Field Formula Tool (which really only works because you only want 2 columns).

Transpose Tool would be the more appropriate tool in general for a problem like this followed by Text To Columns Tool (set to output to rows).

[Anudeep_Yalamuru]

Thanks Andrew. This is good enough. Yes i have few more transposes and fixes to be done after this. I needed only two columns as I will have only 2 fields attached. 

Regards,

Anudeep

[Anudeep_Yalamuru]

Just a question on why two multi-fields Andrew? @CoG 

[CoG]

Multi-Field Tools cannot create new a column and update a column at the same time. The first Multi-Field Tool captures the second part after a ",", then second Multi-Field Tool goes back through the data to get rid of the second part that was just extracted.

[flying008]

Hi, @Anudeep_Yalamuru 

If you need split to n columns by dot:

[grazitti_sapna · Accepted solution]

Hi @Anudeep_Yalamuru 
Another way of doing this.
If it works for for you. Kindly accept it as Solution.
Thanks