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 .