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
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) + '%'