Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: Parsing Pipe Delimited Multi-line File

by Plankton (Vicar)
on Feb 04, 2004 at 18:42 UTC ( [id://326556]=note: print w/replies, xml ) Need Help??


in reply to Parsing Pipe Delimited Multi-line File

Sorry if this is off topic, but the answer might depend on the database you are planning to use. For example if you where going to load this data into an Oracel database I would suggest using Oracle's sqlldr instead of a Perl script.

Plankton: 1% Evil, 99% Hot Gas.
  • Comment on Re: Parsing Pipe Delimited Multi-line File

Replies are listed 'Best First'.
Re: Re: Parsing Pipe Delimited Multi-line File
by silent11 (Vicar) on Feb 04, 2004 at 19:26 UTC
    Also, if you are using MySQL read up on the LOAD DATA INFILE command. This will also remove perl as a middle man.


    -silent11

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://326556]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others scrutinizing the Monastery: (5)
As of 2024-04-16 05:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found