How to delete \N

[hpuxrox]

Im trying to delete \N from a file. This is literal \N not the return charter.

I try,

tail crfdata.csvtmp10903 | tr -d '\\N'

This is deleting anything with N in the file. Does anyone know how to do this correctly?

[James R. Ferguson]

Hi:

# tr -d "\016"

See the ascii(5) manpages.

Regards!

...JRF...

[Sandman!]

Try with sed(1) instead:

# sed 's/\\N//' crfdata.csvtmp10903

[Laurent Menase]

In fact tr treat char by char
tr -d "\\N" will remove \ and N from the file
so
\ANC\DERN
will be transformed in:
ANCDER

indeed it is better to use sed -e "s/\\N//g" outputfile

the g is for removing all the \N
without g it will be only the first one.