in reply to Parsing Pipe Delimited Multi-line File
What have you tried and what has failed?
First off, you have to open the file, read each line in, split it on the pipes and then depending on the database in question use DBI or something similar to access the database with the appropriate SQL statements to insert the data into the proper table.
As I asked in my first paragraph, what have you tried and what has failed? The Perl Monks are a helpful lot but we kinda insist on others at least attemtpting helping themselves first.
| Peter L. Berghold -- Unix Professional Peter at Berghold dot Net | |
| Dog trainer, dog agility exhibitor, brewer of fine Belgian style ales. Happiness is a warm, tired, contented dog curled up at your side and a good Belgian ale in your chalice. | |
|
|---|