how to copy and paste from this?

[qxygene]

i have an old sql file from phpbb lines are like this;

INSERT INTO phpbb_users VALUES (702, 1, 'Harley Beau', '827ccb0eea8a706c4c34a16891f84e7b', 0, 0, 0, 1185428727, 0, 0, -12.00, 1, 'albanian', 'D M d, Y g:i a', 0, 0, 0, 0, 0, NULL, 1, 1, 0, 1, 1, 1, 1, 1, 0, 1, 1, 0, '', 0, '[e-mail]', '', 'http://www.seamcat.org/xwiki/bin/download/XWiki/NoraMilton/amateurpics.html', 'Somethere', '', '', '', '', '', '', '', '', NULL);

INSERT INTO phpbb_users VALUES (703, 1, 'Fertassal', '91f004cf5aa5e8f7580b3a8001b17acd', 0, 0, 0, 1185473363, 0, 0, -12.00, 1, 'albanian', 'D M d, Y g:i a', 0, 0, 0, 0, 0, NULL, 0, 1, 0, 1, 1, 1, 1, 1, 0, 1, 1, 0, '', 0, '[e-mail]', '135664', 'http://www.mulka.ru', 'Russia', '', '', '', '', '', 'news and links', 'download MP3', '', NULL);

i would like to create a new text document and copy paste only email addresses from this sql file..

Text Doc. will be like this;

[e-mail]
[e-mail]

any idea?

[rowanparker]

So you want to extract all email address from an sql file?

You could just search for a @ then just get whatever is either side of it.
But I wouldn't know how to do that.

[roscor]

"SELECT * from  phpbb_users WHERE email like '%@%'";

not sure if this is what you want or something similar. I would have thought that the email from the insert should be going into a column titled 'email'? The above SELECT may then work.

[Horizon88]

He wants to extract the email address from a text dump of an old SQL dbase, if I understand him properly. He doesn't have the actual base anymore so a SELECT won't do it.

The only thing I could think of would be a regular expression that matches any string with an @ inside it, and matches back out until it hits a ' on each end.

I don't know regular expressions well enough to write that, though, let me look around.

Edit:

$contents = file_get_contents('filename-of-sql-dump.sql');
$expression = "/[']*[@]*[']/i";

// if/preg_match stuff here.  on match, write email to array, dump
// array into file at end of loop?

That regex probably won't work as-is, but it should be something like that, perhaps.

But I have a sneaking suspicion that you're harvesting email addresses, so maybe you need to make a match that fits horizon* and filters those emails out, just in case. 😛

[HalfaBee]

probably something along the lines of

preg_match_all( "/'.@.'/" , $sql , $results );