Google Answers Logo
View Question
 
Q: Help with Regular Expression string conversion ( No Answer,   0 Comments )
Question  
Subject: Help with Regular Expression string conversion
Category: Computers > Programming
Asked by: elevatedworks-ga
List Price: $2.00
Posted: 30 Sep 2005 09:04 PDT
Expires: 30 Oct 2005 08:04 PST
Question ID: 574646
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.
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy