When I run a query on a table and then copy the results directly into EXCEL on some lines I find that the row from SQL has appeared to truncate at a particular point and copy onto the next line. I took a look in Notpad and see that the break shows CRLF in the offending place.
How do I run a script to remove Carriage returns (hidden characters) from a field
ERMO1425 Omikron Data Quality GmbH Reseller EXE Omikron Data Quality GmbH -- the line broke here in excel notepad shows CRLF
NULL 1 A6UJ9A00087T --- this appeared on the 2nd line in excel but should be on one line
set fieldname = don't know the syntax to remove any special characters?
would I have to do this on ever field in a table or is there a global setting somewhere that helps when copying data from sql to excel?