text file problems

[Edgar Allen]

KUCHARSKI, DAVID R. writes:
>
>I'm trying to load database info from a text file into postgresql.  the
>text files came with headers and everything.  those were stripped in VI
>leaving only the data to be imported.  using COPY FROM I was able to
>import 9 0f 15 files no problem.  6 are giving me fits.  I'm thinking
>that there is some unreadable control character that is gumming up the
>works.  does anyone know of a way to view these unreadable characters so
>that I can try to get the files loaded?
>
tr -cd 'a-zA-Z0-9011' <infile | od -c | less

Then when you know what the strange characters are
write back with more info and we will see what to do next.