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

If you are getting the values directly from the database when using the Smart Service, you might not be able to use an Appian function. Have you tried using something like: SET Name = REPLACE(Name,' " ', ' ' ) in your SQL code to remove the quotes from that value?
Otherwise, as Jamal said, you could consider using the stripwith() or cleanwith() functions before you save the values into the database to being with, which would remove this downstream issue.

If you are getting the values directly from the database when using the Smart Service, you might not be able to use an Appian function. Have you tried using something like: SET Name = REPLACE(Name,' " ', ' ' ) in your SQL code to remove the quotes from that value?
Otherwise, as Jamal said, you could consider using the stripwith() or cleanwith() functions before you save the values into the database to being with, which would remove this downstream issue.

Thanks for the response,

The behaviour of the Plugin is quite weird.

For one of the column having long statements as value, the value is getting enclosed in "" but in the same column if you have just 2 words like Prakhar Garg then 1st word is coming in 1st line and automatically 2nd word comes in other line in txt file but without "".

I am getting values directly from table using sql script.

I am not sure what I am missing.

Can you share how you configured the "SQL" parameter in the "Export SQL to Flat File" smart service?

Hi,

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

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

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.

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

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)

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

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

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