Issue in rewriting to CSV

[Htwe_Ko_Ko_Wynn]

Hi Experts!

Currently i am testing a program that can convert “,” into space by reading orignial csv.
The problem now i face is i can’t rewrite due to indexing problem.
The original excel file will be:

What I want to convert will be
test.xaml (16.5 KB)

Can someone please help me with it?

[Nithin_P (Nithin Prabhu)]

Hello @Htwe_Ko_Ko_Wynn,

There is a catch here. The CSV Delimiter shouldn’t be present in the data ! What’s happening here is Te,ster -> Te (Is One Column) & ster (Next Column). I recommend you generating the CSV file with a delimiter like ~ or ^ so as to ensure that these characters don’t appear in CSV Data.

If you can share the CSV, I can take a look at it.

Kudos ! Hope that helps.

Regards,
Nithin