More fun with Excel, vim saves the day

My fun with Excel continues.  I exported a sheet to a CSV and it had lovely Microsoft formatted characters such as ” and ” that needed replacing.  When you look at these in vim or less, you will see items like <92> and <93>.  To replace these, just do:

:%s/Ctrl+V x 92//g

That’s hold Ctrl and hit v, then release Ctrl, hit x, and type 92.  You will see vim respond accordingly.  MS DIAF IMO.

Tags: , ,

Leave a Reply