Add double quotes around column text in datatable

When tried to add Quotes around each column data ,nothing is working as expected .
Tried chr(34) ,"""" .,\ escape character

Can anyone help me with this

hope we have a datatable ready named dt
–now use a for each row loop and pass the above variable dt as input
–inside the loop use a assign activity like this
row(“Columnname”) = “”"" + row(“Columnname”).ToString+""""
which will add double quotes on either side of the test in the specified column

Cheers @Chaitanya_Chunduru

 CHR(39)& CHR(34) & CHR(34)  

Tried even .
Output coming as ““test””.
When using

“”"+myString + “”"

Hi @ Chaitanya_Chunduru,

Use like my print:

First Quote “”" <— 3 times
Second Quote “”" <— 3 times

isnt it exactly what i just showed him? 3 times before and 3 times after?

1 Like

@ bcorrea, very sorry i didnt get to read your post

i tried all the options which you all suggested before.While using writeline its working but when used in datatable and write to textfile its not working

Please take a look at my tests here: Main.xaml (6.3 KB)


You can’t Assign Col Name with “col”

Col name cannot be with “Col” if you try to assign also it will take “”" …

For that you can use single double quotes like below


Refer Below xaml

Main.xaml (8.0 KB)

Otherwise after converted as string then you can able to put " double quotes