how to leech email from database

i normally go with raptor and split those columns

but， it may made some mistake or confuse with the ID and email
which one related to which one??
i have tried to use Perl to seperate those stuff, but it is difficult
i'm perl starter

well, the easiest way is to do the correct query :D
"select email from whatever" :D :D

[Jayman]

Originally Posted by Final Sephiroth

well, the easiest way is to do the correct query :D
"select email from whatever" :D :D

You're right, that's if you have access to an SQL Interpreter/Program :)

[Jayman]

but， it may made some mistake or confuse with the ID and email
which one related to which one??
i have tried to use Perl to seperate those stuff, but it is difficult
i'm perl starter

Wow, talk about ages before I read that joe :p

The problem arises when the databases uses a seperator in a text field.

So if you use a comma as a seperator and there is a field text like 'joe, jack','turner' then you'll get 2 seperators instead of the 1 you want. That's when you need ultraedit so you can replace the seperator with something that is unique.

I generally use ultraedit to prepare a database.

Replace ',' with jimeous
Replace , with ;
Replace jimeous with ','

So

'joe, jack','turner'

'joe, jackjimeousturner'

'joe; jackjimeousturner'

'joe; jack','turner'

simple really.

Just use Ultraedit.

Use the replace function to replace ',' with a dozen or so spaces
then using column mode cut the email addies and paste to a new file & save.