Finding and replacing characters between ""
Posted on 2006-07-12
I have written a script that exports the content of a DB Table to a CSV file.
This has been done so that a user can edit the information externally and then import once they are done.
One of the fields of this table is a description and the description therefore, in places, requires the use of commas.
The use of commas obviously screws up the format of the document, but I think that if I surround the description field in "" before I export it, I can search for commas between those i.e. "This is a description, it also contains commas".
Upon import I can convert any commas between the "" into , (the ascii HTML symbol for a comma) and then swap them round again when the file is exported.
Could someone please show me how I can do a find replace in a string between 2 set characters i.e. " "
(I have been trying for hours but have given up and come here).
Thanks in advance.