Can anyone out there help me transform an insert string from Movable
Type into a new, custom insert string?
This is one of the current strings:
INSERT INTO `photo_entries` VALUES (133, 'Tracks', NULL, NULL,
'src=IMG_1206a\ncolorone=333\ncolortwo=999\ndarkness=yes', NULL, NULL,
NULL, NULL, '2005-03-03 08:15:11', '20050912175203', NULL, NULL,
'tracks', 'tag:www.treemeat.com,2005://1.133', 200509);
These are the values I need to get out of it (in {}'s):
INSERT INTO `photo_entries` VALUES ({ID}, '{TITLE}', NULL, NULL,
'src={FILEURL}\ncolorone={COLORMAIN}\ncolortwo={COLORMAIN}\ndarkness=yes',
NULL, NULL, NULL, NULL, '{DATETIME}', '{TIMESTAMP}', NULL, NULL,
'tracks', 'tag:www.treemeat.com,2005://1.133', 200509);
This is what I want those values to be put into:
INSERT INTO `photo_entries` VALUES (ID, 'TITLE', 'FILEURL.jpg',
1, 1, 'DATETIME', '', 'COLORMAIN', 'COLORACCENT', 0, 0,
'TIMESTAMP');
I'm using BBEdit's grep-and-replace, so if anyone has additional
insight into what I should do to make that work best, I'm all ears. |