哪位大神会UE?-------请进来指导下如何换行（谢谢，已解决）

vcxz

1、一个原汁原味的数据（请注意：全部连在一起，总共就一行没有分开行，没有空格）：





INSERT INTO `member` VALUES (242047,'ll','636cf748dddaa59d','87890910','liuliang@qingdaonews.com','219.146.89.58','2011-08-19 14:21:56',0,1,371,NULL,1,NULL,NULL,NULL),(3015977,'pusha126','6df1db0ba067d5ba','19920408','lthljr@163.com','119.178.199.212','2011-04-22 15:54:23',0,0,20,'',1,NULL,NULL,NULL),(242049,'无人牵挂','1511b4f6020ec61d','654321','angelyork@126.com','10.10.16.27','2007-07-29 00:03:09',0,0,106,NULL,1,NULL,NULL,NULL),(242050,'神龙达汽车','8ad9902aecba32e2','000000','xxzxwjy@163.com','60.209.73.190','2009-08-04 18:23:01',0,0,500,NULL,1,NULL,NULL,NULL),(242051,'drynl','ff8aaa8a2dde9154','123321','drynl@china.com','202.110.193.11','2003-11-28 16:41:03',2,0,218,NULL,1,NULL,NULL,NULL),(242052,'lovexb','e50303e1e6faae20','lz0ldalq','lovexb@163.net','','0000-00-00 00:00:00',0,0,100,NULL,1,NULL,NULL,NULL),(242053,'yuanjing_chn','137d38421ee51a82','19771108','yuanjing_chn@yahoo.com','','0000-00-00 00:00:00',0,0,100,NULL,1,NULL,NULL,NULL),(242054,'hongye','5aed192201deb9e8','790908','wlin79@263.net','123.234.246.215','2011-03-28 14:19:22',1,0,3260,NULL,1,NULL,NULL,NULL),(242055,'yyyxxxfff','17f0019c64b042e4','987654','yxf@fei.com.cn','124.129.161.81','2009-06-01 22:47:51',0,0,598,NULL,2,NULL,NULL,NULL),(242056,'guochengqiang','7412b5da7be0cf42','1234567','teacher@zuowen.com','','0000-00-00 00:00:00',0,0,100,NULL,1,NULL,NULL,NULL),(242057,'mei90','2c0a7875bbb53bed','790104','mei90@china.com','','0000-00-00 00:00:00',0,0,100,NULL,1,NULL,NULL,NULL),(242058,'qddlm','a85c12f6e899e26c','dlm0518','qddlm@sina.com','','0000-00-00 00:00:00',0,0,100,NULL,1,NULL,NULL,NULL),(242059,'qddzk','730d9f35de7ac538','qazwsx','qddzk@163.com','','2011-12-27 09:42:00',0,0,100,NULL,1,NULL,NULL,NULL),(242060,'sea','0a49ac941168bee5','lyj122768','bk777@sina.com','221.215.198.141','2011-12-08 09:07:47',0,0,100,NULL,1,NULL,NULL,NULL),(242061,'岛城球迷','cd1655a86115c26e','yue593','hbyue@ms.qdio.ac.cn','124.129.246.197','2010-07-23 14:41:11',0,0,311,NULL,2,NULL,NULL,NULL),

2、想用UE把它变成：

最常用的基本标准（注意：里面有空格的。已分开行）

242047 ll 636cf748dddaa59d 87890910 liuliang@qingdaonews.com 219.146.89.58 2011-08-19 14:21:56 0 1 371 NULL 1 NULL NULL NULL
3015977 pusha126 6df1db0ba067d5ba 19920408 lthljr@163.com 119.178.199.212 2011-04-22 15:54:23 0 0 20  1 NULL NULL NULL
242049 无人牵挂 1511b4f6020ec61d 654321 angelyork@126.com 10.10.16.27 2007-07-29 00:03:09 0 0 106 NULL 1 NULL NULL NULL
242050 神龙达汽车 8ad9902aecba32e2 000000 xxzxwjy@163.com 60.209.73.190 2009-08-04 18:23:01 0 0 500 NULL 1 NULL NULL NULL
242051 drynl ff8aaa8a2dde9154 123321 drynl@china.com 202.110.193.11 2003-11-28 16:41:03 2 0 218 NULL 1 NULL NULL NULL
242052 lovexb e50303e1e6faae20 lz0ldalq lovexb@163.net  0000-00-00 00:00:00 0 0 100 NULL 1 NULL NULL NULL
242053 yuanjing_chn 137d38421ee51a82 19771108 yuanjing_chn@yahoo.com  0000-00-00 00:00:00 0 0 100 NULL 1 NULL NULL NULL
242054 hongye 5aed192201deb9e8 790908 wlin79@263.net 123.234.246.215 2011-03-28 14:19:22 1 0 3260 NULL 1 NULL NULL NULL
242055 yyyxxxfff 17f0019c64b042e4 987654 yxf@fei.com.cn 124.129.161.81 2009-06-01 22:47:51 0 0 598 NULL 2 NULL NULL NULL
242056 guochengqiang 7412b5da7be0cf42 1234567 teacher@zuowen.com  0000-00-00 00:00:00 0 0 100 NULL 1 NULL NULL NULL
242057 mei90 2c0a7875bbb53bed 790104 mei90@china.com  0000-00-00 00:00:00 0 0 100 NULL 1 NULL NULL NULL
242058 qddlm a85c12f6e899e26c dlm0518 qddlm@sina.com  0000-00-00 00:00:00 0 0 100 NULL 1 NULL NULL NULL
242059 qddzk 730d9f35de7ac538 qazwsx qddzk@163.com  2011-12-27 09:42:00 0 0 100 NULL 1 NULL NULL NULL
242060 sea 0a49ac941168bee5 lyj122768 bk777@sina.com 221.215.198.141 2011-12-08 09:07:47 0 0 100 NULL 1 NULL NULL NULL
242061 岛城球迷 cd1655a86115c26e yue593 hbyue@ms.qdio.ac.cn 124.129.246.197 2010-07-23 14:41:11 0 0 311 NULL 2 NULL NULL NULL
242062 richardxu2000 906087dc1256bb44 asdfghjk richardxu98@yahoo.com  0000-00-00 00:00:00 0 0 101 NULL 1 NULL NULL NULL
242063 guogang006 971019336af02550 7931 guogang006@hotmail.com  0000-00-00 00:00:00 0 0 100 NULL 1 NULL NULL NULL
242064 cyberboy b38409bd3e236547 3621412 cyberboy@chinese.com 221.0.149.227 2005-02-11 02:07:16 0 0 132 NULL 1 NULL NULL NULL
242065 haib


最理想把它变成这样的标准（注意：里面有空格的。已分开行）

242047 ll 636cf748dddaa59d 87890910 liuliang@qingdaonews.com
3015977 pusha126 6df1db0ba067d5ba 19920408 lthljr@163.com
242049 无人牵挂 1511b4f6020ec61d 654321 angelyork@126.com
242050 神龙达汽车 8ad9902aecba32e2 000000 xxzxwjy@163.com
242051 drynl ff8aaa8a2dde9154 123321 drynl@china.com
242052 lovexb e50303e1e6faae20 lz0ldalq lovexb@163.net
242053 yuanjing_chn 137d38421ee51a82 19771108 yuanjing_chn@yahoo.com
242054 hongye 5aed192201deb9e8 790908 wlin79@263.net
242055 yyyxxxfff 17f0019c64b042e4 987654 yxf@fei.com.cn
242056 guochengqiang 7412b5da7be0cf42 1234567 teacher@zuowen.com
242057 mei90 2c0a7875bbb53bed 790104 mei90@china.com
242058 qddlm a85c12f6e899e26c dlm0518 qddlm@sina.com
242059 qddzk 730d9f35de7ac538 qazwsx qddzk@163.com
242060 sea 0a49ac941168bee5 lyj122768 bk777@sina.com
242061 岛城球迷 cd1655a86115c26e yue593 hbyue@ms.qdio.ac.cn
242062 richardxu2000 906087dc1256bb44 asdfghjk richardxu98@yahoo.com
242063 guogang006 971019336af02550 7931 guogang006@hotmail.com
242064 cyberboy b38409bd3e236547 3621412 cyberboy@chinese.com
242065 haibianchf 70fc5fcfc6a3ce2f 721103 ggqqjj0657@sina.com
242066 Yu Ning 45a4cb522fa0940a 8996036
242067 鸿福林 2be4cc876327c9de w_28 x_x2922@sohu.com



最差也要把它变成最基本的需要（注意：没空格，只有原来的符号）

242047,ll,636cf748dddaa59d,87890910,liuliang@qingdaonews.com,219.146.89.58,2011-08-19 14:21:56,0,1,371,NULL,1,NULL,NULL,NULL
3015977,pusha126,6df1db0ba067d5ba,19920408,lthljr@163.com,119.178.199.212,2011-04-22 15:54:23,0,0,20,,1,NULL,NULL,NULL
242049,无人牵挂,1511b4f6020ec61d,654321,angelyork@126.com,10.10.16.27,2007-07-29 00:03:09,0,0,106,NULL,1,NULL,NULL,NULL
242050,神龙达汽车,8ad9902aecba32e2,000000,xxzxwjy@163.com,60.209.73.190,2009-08-04 18:23:01,0,0,500,NULL,1,NULL,NULL,NULL
242051,drynl,ff8aaa8a2dde9154,123321,drynl@china.com,202.110.193.11,2003-11-28 16:41:03,2,0,218,NULL,1,NULL,NULL,NULL
242052,lovexb,e50303e1e6faae20,lz0ldalq,lovexb@163.net,,0000-00-00 00:00:00,0,0,100,NULL,1,NULL,NULL,NULL
242053,yuanjing_chn,137d38421ee51a82,19771108,yuanjing_chn@yahoo.com,,0000-00-00 00:00:00,0,0,100,NULL,1,NULL,NULL,NULL
242054,hongye,5aed192201deb9e8,790908,wlin79@263.net,123.234.246.215,2011-03-28 14:19:22,1,0,3260,NULL,1,NULL,NULL,NULL
242055,yyyxxxfff,17f0019c64b042e4,987654,yxf@fei.com.cn,124.129.161.81,2009-06-01 22:47:51,0,0,598,NULL,2,NULL,NULL,NULL
242056,guochengqiang,7412b5da7be0cf42,1234567,teacher@zuowen.com,,0000-00-00 00:00:00,0,0,100,NULL,1,NULL,NULL,NULL
242057,mei90,2c0a7875bbb53bed,790104,mei90@china.com,,0000-00-00 00:00:00,0,0,100,NULL,1,NULL,NULL,NULL
242058,qddlm,a85c12f6e899e26c,dlm0518,qddlm@sina.com,,0000-00-00 00:00:00,0,0,100,NULL,1,NULL,NULL,NULL
242059,qddzk,730d9f35de7ac538,qazwsx,qddzk@163.com,,2011-12-27 09:42:00,0,0,100,NULL,1,NULL,NULL,NULL
242060,sea,0a49ac941168bee5,lyj122768,bk777@sina.com,221.215.198.141,2011-12-08 09:07:47,0,0,100,NULL,1,NULL,NULL,NULL
242061,岛城球迷,cd1655a86115c26e,yue593,hbyue@ms.qdio.ac.cn,124.129.246.197,2010-07-23 14:41:11,0,0,311,NULL,2,NULL,NULL,NULL
242062,richardxu2000,906087dc1256bb44,asdfghjk,richardxu98@yahoo.com,,0000-00-00 00:00:00,0,0,101,NULL,1,NULL,NULL,NULL
242063,guogang006,971019336af02550,7931,guogang006@hotmail.com,,0000-00-00 00:00:00,0,0,100,NULL,1,NULL,NULL,NULL
242064,cyberboy,b38409bd3e236547,3621412,cyberboy@chinese.com,221.0.149.227,2005-02-11 02:07:16,0,0,132,NULL,1,NULL,NULL,NULL
242065,haibianchf,70fc5fcfc6a3ce2f,721103,ggqqjj0657@sina.com,,0000-00-00 00:00:00,0,0,100,NULL,1,NULL,NULL,NULL
242066,Yu Ning,45a4cb522fa0940a,8996036,swg@hi-tech.chinaqingdao.net,,0000-00-00 00:00:00,0,0,100,NULL,1,NULL,NULL,NULL
242067,鸿福林,2be4cc876327c9de,w_28,x_x2922@sohu.com,,0000-00-00 00:00:00,0,0,100,NULL,1,NULL,NULL,NULL






请大神给指导！感谢！


我找“自动换行”及“编辑里的高级，没找到这个功能。实在不会了，只好来求助，添麻烦了。

vcxz

感兴趣的，学习的，帮顶个贴。


等待大神出现

随风飘

先说第一个
删除前面的ID
^\(\d{1,8}\,\'
如果只要密码就继续删除掉第二例用户名
^.*\'\,\'
第三例就是密码了（MD5的我也不知道干啥用）留下了。
去掉密码后面的：
\'\,\'.*$
如果用户名、密码、邮箱都要这个
\'\,\'这里匹配IP.*$

检查^.{120,}
再\'\,\'找到规律匹配.*$

检查^.{120,}
再\'\,\'找到规律匹配.*$

经刚才试验好像需要几次的样子。

','替换成空格
再,'替换成空格
这个空格最好用那个特别的空格，比较长些的，或者换其它分隔符号，有时有空格是密码


换码字符\
这个有些版本有些字符不需识别，可以不用。

匹配IP:
(25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])\.(25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])\.(25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])\.(25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])

vcxz

楼上大神来了。怕你忙，没直接找你，怕给你添麻烦


感谢中



打开后，应该是这样的下面的附件

ncwuzheng

不知道是什么情况，帮顶

随风飘

需要注意每次匹配后检查处理行数
用^.{100,}检查是否处理完整。
..........其它的看情况注意


花了十多分钟找到原文件重新看了一下
如图

vcxz

奇怪了，确实是这样