How to save CSV with comma delimiter?

Hi Community,
i need to save CSV file with Comma separated values like below

P.S : Comma delimiter in write CSV activity is not working.
Please advice on this.

Thanks in advance.
Cheers!
Kumar.

Hi,

How about the following?

Regards,

Hi Yoichi,

its not working, i’m just getting 1st column alone.
PFB the input excel.


Need output like as mentioned previous post.

Cheers!
Kumar.

Hi,

Oh, the first image is output, isn’t it? How about the following? This returns like the first image sheet and a csv file.

Sequence4.xaml (7.2 KB)

Regards,

@skaruppanakumar

Have you use write csv activity?

But what is your input?

Thanks

Hi Yoichi,

i am getting error in Assign activity,

Hi,

If possible, can you share your data as a file? It’s no problem if dummy data.

Regards,

The error seems pretty clear. What does it say?

Hi,

Sorry, I forgot to change settings of max length. Can you try the following?

Sequence4.xaml (6.9 KB)

Regards,

Hi Yoichi,

It works!
Thanks a lot!
But when i view that CSV in edit mode, it shouldn’t contain double quotes in start and end point of the string.
image
Please advice on this.

Cheers!
Kumar.

Hi,

The above workflow outputs 2 files : result.xlsx and result.csv. Which file do you mention for?

Regards,

Hi,
i meant CSV file (result.csv).

Cheers!
Kumar.

Hi,

Can you try the following workflow?

Sequence4.xaml (7.1 KB)

Regards,

Hi Yoichi,

Sorry!
its not working.

Hi,

If possible, can you share your data as a file? It’s no problem if dummy data.

Regards,