So I'm converting an Excel Spreadsheet to a SQL script and I forgot to escape the single quotes before surrounding all of the data with single quotes, which won't run in SQL of course. Usually I just start over, today I took it upon myself to determine how I can find these offending single quotes with a vim RegEx. Voila:


The only ones this misses is single quotes at the beginning or end of a field, like: ''Bobby Smith'', which should be escaped '''Bobby Smith''', but these are much easier to hunt down with all other cases taken care of with a simple :g//s//''/g knowwhatimean?