Separate , values in CSV and paste into another sheet

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

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 :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

@saikumar

Check as below

Filter Datatable Details

Mark as solution if this helps

Thanks

2 Likes

Hi @saikumar,

Please try Filter Datatable

image

Thanks,

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.