[Talk] Data Processing and SQL INSERTING

[Jeff Bisbee]

Seems like a job for Perl to me.  I'd be more than happy to work out any
kinks you have if you go that route.

* GreenFROG Design (info@greenfrogdesign.net) wrote:
> Data Processing and SQL INSERTING
> 
> Hello guy's I'm faced with a horrible dilemma I have whole dictionary that I
> have to enter into a database. I have all the text and I would like to
> convert it into a sql insert query so I don't have to enter all that data
> manually. I would like some recommendation on the best way I could get this
> data into the data. If anyone has any suggestions please help. this is what
> I'm facing. 
> 
> 
> This is how data is originally
> 
> Step 1: 
> 
> dominize - 1. To line up dominoes in interesting patterns and knock them
> over, causing the domino effect. 2. To do this with any other multiple
> rectangular objects. 3. To utterly destroy the whole by defeating one small
> part, much in the same manner.
> e.g., Did you see that episode of "America's Funniest Home Videos" where
> those guys dominized a thousand empty VHS cases? That was awesome.
> submitted by BigAssFries - (www)
> 
> 
> Step 2: remove "submitted by BigAssFries - (www)"
> 
> dominize - 1. To line up dominoes in interesting patterns and knock them
> over, causing the domino effect. 2. To do this with any other multiple
> rectangular objects. 3. To utterly destroy the whole by defeating one small
> part, much in the same manner.
> e.g., Did you see that episode of "America's Funniest Home Videos" where
> those guys dominized a thousand empty VHS cases? That was awesome.
> 
> 
> 
> Step 3: Separate text * when there is more then one meaning there are
> numbers other wise there aren't. example" dome - "your head, above the
> face." 
> e.g., "John just got mugged! They slapped a lead pipe against his dome!"
> submitted by dust" there are also sometimes " at the beginning of meaning
> and some times not.
> 
> dominize - 
> 1. To line up dominoes in interesting patterns and knock them
> over, causing the domino effect.
> 2. To do this with any other multiple
> rectangular objects.
> 3. To utterly destroy the whole by defeating one small
> part, much in the same manner.
> e.g., Did you see that episode of "America's Funniest Home Videos" where
> those guys dominized a thousand empty VHS cases? That was awesome.
> 
> 
> Step 4: Format text
> 
> dominize - add \" and \'
> 1. To line up dominoes in interesting patterns and knock them over, causing
> the domino effect. 
> 2. To do this with any other multiple rectangular objects.
> 3. To utterly destroy the whole by defeating one small part, much in the
> same manner. 
> e.g., Did you see that episode of \"America's Funniest Home Videos\" where
> those guys dominized a thousand empty VHS cases? That was awesome.
> 
> Step 5: Remove - and e.g.,
> 
> dominize 
> 1. To line up dominoes in interesting patterns and knock them over, causing
> the domino effect. 
> 2. To do this with any other multiple rectangular objects.
> 3. To utterly destroy the whole by defeating one small part, much in the
> same manner. 
> Did you see that episode of "America's Funniest Home Videos" where those
> guys dominized a thousand empty VHS cases? That was awesome.
> 
> 
> Step 6: Create SQl query - NULL is always NULL and yes is always yes the
> numbers must increment look at the example below.
> 
> INSERT INTO vocab VALUES (1, 'dominize', 'yes');
> INSERT INTO meaning VALUES (NULL, 1, 'To line up dominoes in interesting
> patterns and knock them over, causing the domino effect.', NULL, 'Did you
> see that episode of "America's Funniest Home Videos" where those guys
> dominized a thousand empty VHS cases? That was awesome.');
> INSERT INTO meaning VALUES (NULL, 1, 'To do this with any other multiple
> rectangular objects.', NULL, 'NULL');
> INSERT INTO meaning VALUES (NULL, 1, 'To utterly destroy the whole by
> defeating one small part, much in the same manner.', NULL, 'NULL');
> 
> 
> INSERT INTO vocab VALUES (2, 'word #2', 'yes');
> INSERT INTO meaning VALUES (NULL, 2, 'To line up dominoes in interesting
> patterns and knock them over, causing the domino effect.', NULL, 'Did you
> see that episode of "America's Funniest Home Videos" where those guys
> dominized a thousand empty VHS cases? That was awesome.');
> 
> 
> 
> INSERT INTO vocab VALUES (2, 'word #3', 'yes');
> INSERT INTO meaning VALUES (NULL, 3, 'To line up dominoes in interesting
> patterns and knock them over, causing the domino effect.', NULL, 'Did you
> see that episode of "America's Funniest Home Videos" where those guys
> dominized a thousand empty VHS cases? That was awesome.');
> INSERT INTO meaning VALUES (NULL, 3, 'To line up dominoes in interesting
> patterns and knock them over, causing the domino effect.', NULL, 'NULL');
> 
> _______________________________________________
> Talk mailing list
> Talk@flux.org
> http://www.flux.org/mailman/listinfo/talk
>