How to save CSV with comma delimiter?

Help Activities
, ,
1

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

image
image982×410 100 KB

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

Thanks in advance.
Cheers!
Kumar.

2

Hi,

How about the following?

img20211216-4
img20211216-4779×414 23.4 KB

Regards,

3

Hi Yoichi,

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

image
image998×450 80.2 KB

Need output like as mentioned previous post.

Cheers!
Kumar.

4

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.

img20211216-6
img20211216-6627×742 18.1 KB

Sequence4.xaml (7.2 KB)

Regards,

5

@skaruppanakumar

Have you use write csv activity?

But what is your input?

Thanks

6

Hi Yoichi,

i am getting error in Assign activity,

image
image867×386 43.9 KB

7

Hi,

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

Regards,

8

The error seems pretty clear. What does it say?

9

Hi,

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

Sequence4.xaml (6.9 KB)

Regards,

10

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.

11

Hi,

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

Regards,

12

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

Cheers!
Kumar.

13

Hi,

Can you try the following workflow?

Sequence4.xaml (7.1 KB)

Regards,

14

Hi Yoichi,

Sorry!
its not working.

15

Hi,

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

Regards,

16

hi Yoichi,

I am already using your recommendation workflow, but the result is not as expected,

please review this attachment below

Untitled