Varchar/delimiter problem 1

[similici]

I have a table with a field declared varchar(15,0) .
When I make a statement like "select nume_field from table_name ..." the record returned is

AMI/|? IT 00


but when I'm unloading into a file

("unload to file.txt select nume_field from table_name...")

it looks like this:

AMI/^S|^M? IT 00

How can I lose the Ctrl+S, Ctrl+M characters?

Can you help me?
Thank you .

 

[vpshriyan]

You may use:
sed 's/^M//g' input_file > output_file

Note: ^M is Ctrl+v Ctrl+m