Newline character in a SQL query in Clear SCADA?

[mhayat]

I'm trying to export data from one system to import into another using CSV and new line characters in notes are making it difficult. I have tried the following query to get the data but it isn't working. Is there a way to replace newline characters in a SQL query in ClearSCADA?

I have tried the following query and tried this "Replace( "Message", '\n', '{3}' )" in it but didnt work for me:

SELECT TOP( 100000 )
"RecordId", "SeverityDesc" AS "~SeverityDesc", "RecordTime" AS "~RecordTime", Replace( "Message", '\n', '{3}' ) AS "Message", "User", "Category", "Foreground", "SeqNo", "CommentNo"
FROM
CDBEVENTJOURNAL
WHERE
( "~RecordTime" BETWEEN { OPC 'H-23H' } AND { OPC 'H+1H' } ) AND ( "Id" = 772856 )
ORDER BY
"~RecordTime" DESC, "SeqNo" DESC, "CommentNo" ASC

[Hardin4019]

If you are using the SQL Export object with that query, I wouldn't think that you need the /n for a new line at all. Maybe I'm missing what the Replace and {3} are for. But I would change  Replace( "Message", '\n', '{3}' ) AS "Message"  to "Message" AS "Message".