Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    2

    Arrow Unanswered: Inserting old html files in mysql

    Hey there,

    I'm quite new to the whole database world, and I seem to be having problems with html inserting in a database. Im not sure how to tackle this:

    I've got around 1000 pages of html code, which I would like to incorporate into a database. The tricky part is that parts of the file itself should be put in different columns (e.g. 'title' and 'description'). These parts are well separated in html throughout all 1000 files (e.g. the title is always preceeded by <title> and end with </title>).

    Im positive this problem is solvable... Still, as a newbe I need a bit of help here.

    Thanks in advance!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    the tricky part -- extracting the title, description, etc. -- will require some sort of processing independent of mysql

    i'm sure perl could do it, but i don't do perl
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2006
    Posts
    2
    Quote Originally Posted by r937
    the tricky part -- extracting the title, description, etc. -- will require some sort of processing independent of mysql

    i'm sure perl could do it, but i don't do perl

    Okay, I'll think I sould head over to a forum on Perl and repost my question there... Thanks for you reply!

    ...or maybe someone else has another idea, I'm glad to hear those as well.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •