I have a need to take a flat file FTP'd from Windows to Unix and convert it for loading into a MySQL database without manual intervention. However, some characters are "fancified" (e.g. the fancy Beginning and End double-quotes from Windows) that show up as codes using vi. I need to convert these to regular text in Unix. The codes are below:
<85>=...
<92>=�
<93>=�
<94>=�
Example Text in WordPad
(like a telephone, except �0� at top left
Same Text in Unix
(like a telephone, except <93>0<94> at top left
[Note the difference in the double quotes.]
The codes show up in Putty vi as blue, so I know it recognizes they are metacharacters, but none of the methods I've tried in Unix (sed, awk) to search for metacharacters seems to find these.
rdcwayx, if you type "(like a telephone, except "0" at top ... left" into MS word and save as .txt you will have an example file. Here is and od -c of the file I use to test my solution:
$ od -c myfile.txt
0000000 ( l i k e a t e l e p h o n
0000020 e , e x c e p t 223 0 224 a t
0000040 t o p 205 l e f t \r \n