Pipe-delimited data into MySQL database

[fidibidabah]

I'm boggled.

I have this pipe-delimited data...

and I'd like it in a SQL database. I have access to MyPHPAdmin. I also have ColdFusion v7 server loaded locally and on the server.

It seems I can do absolutely anything _but_ this. Is there some sort of "data massaging" technique that pros know or something? I need to squeeze this thing into a DB. Help :D

(I know this isn't the most appropriate place, but I know the guys here know this kind of stuff)

Thanks :)

[fidibidabah]

Well, I can see this thread is going to quickly turn into a soliliqy.

After pressing buttons at random for 8 years, 2 months, and 16 hours, I've figured it out. Fortunately I was in a time/space vacuum so it was only about 3 hours. Apparently PhpMyAdmin has this built right in, go fig *sigh*.

Now I've got another 8924238 questions, but I'm sure I'll just accidentally run into those to..

Thanks for listening :)

[jasonlambert]

you proberly want LOAD DATA INFILE with FIELDS TERMINATED BY '¦'

also see: [dev.mysql.com...]

EDIT: nm. i've just worked out you replied to your own thread :oops:

[Trisha]

you were lucky you were able to do it that way, my host has LOAD DATA INFILE disabled for 'security' reasons.

[fidibidabah]

Security reasons? Oh c'mon, the max you can load is onl 50,200,000 bites.... 50MB spammed 100,000 times couldn't hurt a server, could it? ;) Hehe, I guess I am lucky, that's quite a security threat. I'm just glad it worked.

Thanks again :)

Oh, and which board is used here for ColdFusion discussion? Webmaster Technology Issues or Webmaster General?