enhanced search and replace

i've got a mysql dump file from an app i'm helping on, but the author added three new fields to one of the tables in the latest release. now the dump file i generated won't import because mysql complains that the number of fields doesn't match that of the dump file (32 fields in the table, the dump file has 29). so i'm trying to come up with a quick command to parse the .sql file, search for the lines that start with INSERT INTO <table> VALUES blah and replace the ); on the end of the line with ,'','',''); so it thinks the three new fields are represented, but blank.

i'd do it by hand if there weren't about 5000 entries to be modified. i was going to just split the lines for this table out since four tables are represented in the dump file, but this is something i'd like to know.... that and i'm slightly regex-retarded.

thanks,
~clay

---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
Received on Wed Feb 23 19:49:53 2005