Shell Programming and Scripting

Hi -

I'm having a problem with hidden characters on Linux. When I produced an output from Oracle database, there is a an extra "Hidden Character" included on the output. How can I remove that character? See below:

The extra dollar sign is creating a new line on my .csv output file. I tried using sed, but no luck.

Note: The '$' is not being included on HP-UX machines upon my query.

Hi

Code:

sed -e 's/InterUnit\$/InterUnit/g'  file.csv > file2.csv

Guru

Try this..

Code:

 
tr -cd '\11\12\40-\176' < myfile1 > myfile2

Hi guru,

Thanks for the fast response but my problem is not solved using sed.

I tried using your command but the Linux still cannot interpret the hidden '$' even if we used a escape character. I can only view the '$' using the "set list" function of vi, but I cannot grep the string using a normal vi.

Also, I tried viewing the file using 'od -c' and the output is below:

The '$' is interpreted as "next line".

---------- Post updated at 03:23 PM ---------- Previous update was at 03:19 PM ----------

Hi itkamaraj,

Can you please explain what the command is doing? I can't see the '$' in there.

UPDATE: I tried the command tr -cd command, but the '$' is still there.

The code i provided is to remove the special characters from the file

Dec value 128 to 225
Hex value 80 to FF

Is the output produced in windows platform ?

try

Code:

 
dos2unix < infile > outf

Code:

 
perl -i -pe 's/\r//g' inputfile

The files will be generated by the script on Linux box, then send the file as attachment to MS Outlook users.

I tried both of the commands, but the '$' is still there. Am I the only one experiencing this?

just try this.

This will remove all the special characters except the keyboard characters

Code:

perl -i -pe 's/[^\x20-\x7f]//g' examplefile

---------- Post updated at 01:16 PM ---------- Previous update was at 01:07 PM ----------

Is the file generated by perl script ?

did u use chomp method for each variable to remove the new line character ?