Export SQL to Flat File (Text Format) - Column Value with Space is coming within Double Quotes

Hi All,

Thanks for your reply.

I got the root cause of this behaviour. This is happening due to "escapeCsv" function used to get the column value and this function has its own properties that if text includes comma/""/new line then text will be enclosed in Quotes.

https://commons.apache.org/proper/commons-lang/apidocs/org/apache/commons/lang3/StringEscapeUtils.html#escapeCsv-java.lang.String-

I will be stripping comma/""/new line before saving the data into database and then when this Plugin will be used for creating file, it will not have any issue (Tested and working fine).

Yes I tried Cast function but still getting text enclosed in Double Quotes

In your Select query, have you tried setting the column as: cast(COLUMN_NAME as char)?

No, I can't see 10, 13 or 9 in the list

Yes it return unicode characters, can you please verify the number 13,10 or 9, is present or not on the text

Hi Vinay,

CODE function in Appian will convert each character of the text provided into its Unicode, so this will not help as if I provide my complete statement it will return list of number integers (As per function definition).

code(
"Hello Everyone a New project has been started by user with following comments XYZ"
) - This will return list of 81 number integer (where 81 is number of characters in text)

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

How to validate for the Unicode characters from database? We have simple statement like "Hello Everyone a New project has been started by user with following comments XYZ" as on of the column value which is getting enclosed in "", but if I reduce the same to "Hello Everyone" no "" are appearing.

if I run the same Select query directly in DB I can see the data correctly, but same data in text file is corrupted.

I think you get some unicode characters from the database,
for debugg please copy the text from the database table and in the appian side used CODE to check if any unicode charcters are present in the text like 10,13,9

Hi,

I am just using simple Select query to get the specific columns and corresponding values from database