Split the data

[mani1304]

Hi there,

I have a requirement that if a semilcolon comes in a record, it should break into number of records but those fields are in the middle. e.g. if record is 100|a-- good to go, but if record is 100|a;,b;c;d then it should break into 4 records as 100|a,100|b,100|c,100|d

Please suggest.

[Anonymous]

Have you tried tNormalize component? I think you can check if the data contains a semicolon and filter the data, use tNormalize to split the data if it contains a semicolon.

Regards

Shong

[mani1304]

Thanks Shong, sorry for the delay response but for the time I got some work around for this but I forgot to mention that this has a lot of columns and the required column is in middle somewhere so I don't think tNormalize for this, Is there something else which can be done here.

[Anonymous]

@Manish Mishra​, I don’t understand you emphasize that these required column is in the middle somewhere. It would be appreciated if you can share your workaround on the community.

Regards

Shong

[madhukolli2003]

Hi @Manish Mishra​ ,

tNormalize can split the value into multiple rows irrespective of column position.

Only limitation is it can only apply on single column.

Please refer below example .

Thanks & Regards,

Madhu Kolli