parse

From: E (epascal_at_triad.rr.com)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 21:34:54 GMT

 does anyone know how to take a text file and do this for mysql. parse your
file and create a new one which is in the
sql-dump-format

ex. of the text i have

in my data file i have ten of these in same format how would i load all in
my database from the text file. what would the mysql command be or should i
add something to separate each actor or what?

IMAGE_NAME: action_2
TITLE: The Lord of the Rings: The Fellowship of the Ring
ACTOR: John Rhys-Davies - Gimli
       Marton Csokas - Celeborn
       Lawrence Makoare - Lurtz
       Billy Boyd - Pippin
       Liv Tyler - Arwen
       Dominic Monaghan - Meriadoc Brandybuck
       Hugo Weaving - Elrond
       Ian Holm - Bilbo Baggins
       Elijah Wood - Frodo Baggins
       Peter Corrigan - Otho [Extended Version]
       Sean Bean - Boromir
       Sean Astin - Samwise Gamgee
       Craig Parker - Haldir
       Cate Blanchett - Galadriel
       Andy Serkis - Gollum
       Viggo Mortensen - Aragorn
       Orlando Bloom - Legolas
       Ian McKellen - Gandalf
       Christopher Lee - Saruman
DIRECTOR: Peter Jackson
RATING: PG-13
NUMBER of DVDs: 4
LENGTH: 165 minutes
GENRE: ACTION
RELEASE DATE: 11/12/2002
ID: 2