Hi All,
I am using Export SQL to Flat File Smart Service where for of the column we have large text value (A paragraph value with spaces) which is enclosed in "" automatically by the Smart service.
Other text values without spaces (E.g. Prakhar_Garg_09_10_2017) is coming perfect without any "" (Quotes).
Please let me know what I am missing here.
Thanks
Discussion posts and replies are publicly visible
You could use the stripwith() or cleanwith() functions to remove the double quotes from that value in a script task right before you execute the "Export SQL to Flat File" Smart Service. please refer to https://docs.appian.com/suite/help/17.3/fnc_text_cleanwith.html and https://docs.appian.com/suite/help/17.3/fnc_text_stripwith.html .
as I already mention use CODE function in Appian Expression Editor,just copy the text from the database and see weather you get any special characters code("Hello Everyone a New project has been started by user with following comments XYZ"),
In the database you can not see the Unicode Characters directly
on the database end you can also try below code to find the newline characters
select * from YourTable where Col1 like '%' + char(10) + '%'