Search and replace

Posted by zx on Stack Overflow See other posts from Stack Overflow or by zx
Published on 2010-05-10T12:47:18Z Indexed on 2010/05/10 12:54 UTC
Read the original article Hit count: 300

Filed under:
|
|

Hi,

I have a really large SQL dump around 400MB.

It's in the following format, "INSERT INTO user VALUES('USERID', 'USERNAME', 'PASSWORD', '0', '0', 'EMAIL', 'GENDER', 'BIRTHDAY', '182', '13', '640', 'Married', 'Straight', '', 'Yes', 'Yes', '1146411153', '1216452123', '1149440844', '0', picture', '1', '0', '0', 'zip', '0', '', '0', '', '', '0')"

Is there anyway I can just get the email and password out from that, I want to import the users into another table.

Anyone know how I can do this and just get email-password stripped out from that content?

Thank you in advance

© Stack Overflow or respective owner

Related posts about perl

Related posts about unix