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
Fine
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
YourString/Row/Column/…
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
“‘‘Test’’”
Refer Below xaml
Main.xaml (8.0 KB)
Otherwise after converted as string then you can able to put " double quotes