I have a .csv file created by a semi-brain dead application that didn't
properly escape quote characters within the fields. I've been trying to come
up with a way to replace one quote character with the proper two quote
characters within the quoted fields, but haven't yet struck upon the magic
sequence.
As an example, the line

"ID",""Brief" Description","State","Assigned User",""Detailed" Description",

(Note  the quotes around "Brief" and "Detailed".)

needs to be changed into

"ID","""Brief"" Description","State","Assigned User","""Detailed""
Description",

(Note, each of the " characters within the fields is transformed into "".)

Can anybody suggest a way to do this?

  -- Jay

--~--~---------~--~----~------------~-------~--~----~
You received this message from the "vim_use" maillist.
For more information, visit http://www.vim.org/maillist.php
-~----------~----~----~----~------~----~------~--~---

Reply via email to