I am looking to remove the carriage returns from a SQL query text file. I am using the following query and i think I should see the CR removed but it isnt.
select ltrim(rtrim(REPLACE(CAST(job_title AS VARCHAR(8000)), CHAR(13),''))) as title FROM mytable
Output :
title Inside Sales Decoration sales FAX AR PAST DUE Design centre Manager President/Owner Expo Guest Only
Depending on the source/destination of your data, you may also need to remove/replace CHAR(10)...
The destination is a flat file. I have tried char(13) + char(10) with no luck as well
Try to replace the tab sign (char(9))
If that doesn't work, you should find out which invisible character is causing the problem. Best way to do that is to open the flat file in notepad ++ (Menu View → Show Symbol → Show All Characters)
19 People are following this question.
