Hi there
I have some CSV files that come with double quote delimiters and every now and then there is a rogue quote in a field that I would like to replace.
I am using TCL as the application has this natively embedded and I am struggling with the regex that would identify this pattern and thus use the regex in the regsub function of TCL. In essence, open the file, loop each line and regsub
Here is an example: 100,"Hello","big",190,"Longer than 10" lengths",99 (I am trying to replace the " after 10 with say zz)
A unix regex of (?<!^|,)"(?!,|$) works a treat, but does not confirm with TCL script.
Any ideas/assistance/alternative approaches...I could use unix (ksh) script, but was keen on TCL for is ease and I use it else where.