wesgarrison.us

Ruby On Rails generates code for you so that you can spend more time working on unique logic and less time writing connect() statements.

I had a .csv file that had some messed up data in it.
The records were quote-qualified, but the last field had quotes in it, so my import thought that was the end of the that field, leaving an extra comma quote.

I used a vim regular expression to parse off the last record:
:%s:^\(.\{-},.\{-},.\{-},.\{-}\),.*:\1:

Using non-greedy matching allowed me to match the first fields and the commas between them, then I match another comma and a greedy .* to match the rest of the line. The \1 refers to the text that matched between the parenthesis, so it just replaces what already there, minus the 4th comma and everything after it.

http://www.geocities.com/volontir/ was a great reference as to vim regular expressions. I don’t use them enough to be super familiar, so I always end up looking them up when I need to use one.