I am writing data into excel using “write csv” activity. One of the input data in Datatable contains comma in its data but is in double quotes = “name,surname”
eg : “abc, def” , but it is entering the data before comma in one column and data after comma in second column.
I want all the data in one single column with the data intact.
Welcome to the community
Ideally it would not write that way…there must be some mistake in the datatable itself please verify the same
To verify properly better open cav as notepad and check
Cheers
in general we have the options:
and can use a less critical column delimiter e.g. Pipe |
Hi,
Seems you are using comma as the delimiter.
Just to make my issue clear the input Dt looks like below -
[Account,0010Y0,“TERKMANE,NAZIM”,Signed_vod,FR
Account,0cHQAV,“FRANGI,ISSAM”,Signed_vod,FR
Account,0010cQAF,“FRACHET,OLIVIER”,Invited_vod,FR]
And the output after using write cell is as below, it divides the data in dt by the comma in the quotes into 2 different columns -
My requirement is to get all the data in one single column.
The property in write cell is this-
delimiter = semicolon
ShouldQoute = checked
Please suggest
Show us output as textfile opened in an texteditor e.g. notepad++ thanks
You can prepare an array by combining all columns of your dt to one array and then convert your array to a dt column and write that to data table
| Column 1 | Column 2 | Column 3 | Column 4 |
|---|---|---|---|
| Account;0010Y0;;TERKMANE | NAZIM;Invited_vod;FR | ||
| Account;0cHQAV;;FRANGI | ISSAM;Signed_vod;FR | ||
| Account;0010cQAF;;FRACHET | OLIVIER;Invited_vod;FR | ||