Separate , values in CSV and paste into another sheet

[saikumar (saikumarrao)]

It is my CSV sheet where ‘X’ column has , values I have to take all values containing , and paste into another sheet

[Pratik_Wavhal]

Hi @saikumar

After reading the csv just use the statement as below within ForEachRow
if row(“X”).ToString.Contains(“,”)
then
WriteCell Activity
else
continue

Mark as solution and like it if it helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[Srini84 (Srinivas Kadamati)]

@saikumar

Check as below

Filter Datatable Details

Mark as solution if this helps

Thanks

[Vara (Varaprasad Rao)]

Hi @saikumar,

Please try Filter Datatable

Thanks,