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: Seperate 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 begining 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');