key combination for � symbol

ceantuco · 06-17-2009, 02:19 PM

sorry it actually ADDED � before ,

15�,210032�,000000�,�,2009-06-13�,09:09:51�,TILLISSUE�,�,�,COMPLETE�,1�,T03�,4346�,04709�,99�,�,S�,�,�,�,0�,0.00�,150.00�,0.00�,0. 00�,09:09:51�,�,0.00�,�,0�,

GazL · 06-17-2009, 02:39 PM

As I said above in the PS. I think it will be the utf-8. Have another go with,

Code:

iconv -f cp437 -t iso8859-1 cesar.csv | tr -d "\r" | tr "\262" "," >cesar.txt

That certainly works with the test file I made here.

ceantuco · 06-17-2009, 02:46 PM

YOU ARE THE MAN! thanks! :d :d :d THANKS FOR YOUR TIME!

GazL · 06-17-2009, 02:54 PM

Phew! thank god for that.

I was beginning to worry there.

You're very welcome, These little puzzles are more fun that playing solitaire or doing a crossword, and if I end up helping someone out, all the better.

Oh, on a final note. The two tr's can be replaced with a single

Code:

sed -e 's/\r$//' -e 's/\o262/,/g'

Though that's slightly more efficent than the two calls to tr, I find the two tr's far more readable myself.

Take care.

ceantuco · 06-17-2009, 02:57 PM

yes! I wrote a script today that would save me so much time!!! and it was fun! lol what can I replace it with?

ceantuco · 06-17-2009, 03:05 PM

thanks again!