
doug1707
New User
Dec 18, 2012, 9:56 PM
Post #1 of 2
(2191 views)
|
Process MYSQL dump FILE
|
Can't Post
|
|
Hello !!! It's been a long time since I programmed in Perl.. and starting over again. I have a file which is the output of MySQL Dump.. it looks like MySQL dump 10.13 Distrib 5.1.63, for debian-linux-gnu (x86_64) INSERT INTO `ACCOUNTING_ARCHIVE` VALUES ('name@g.net.au',1291125601,'Start',6,NULL,NULL,'FF10FFFF5800B09B-4C F5035A',NULL,NULL,'123.2.2.116','2432741531','123.3.225.194',NULL,'N',NULL,NULL),('weee@gwww.com',1291125603,'Stop' ,1,2757,15142,'FF10FFFF58005032-4CF500F3',623,2,'123.2.2.116','2432716850','123.3.225.154',NULL,'N',NULL,NULL), I would like to grab all the text between "(" and ")" and put that to a single record in another file Regards Doug
|