女朋友是一编辑,天天都做同样一件事,很累,很烦,工作倒是容易,就是量太大,请各位大侠帮帮小弟。
有上万条如下数据,存为aaa.txt:中房鑫源(北京)房地产经纪有限公司,王铮","","100022","北京市朝阳区东三环南路54号院4号住宅楼905室","65863388","","010"
"北京路易士房地产经纪有限公司","陆源","","100020","北京市朝阳区东三环中路42号201室","65819229","","010"
"北京昌龙宏业房地产经纪有限公司","刘万君","","100025","北京市朝阳区石佛营东里117号楼218室","85819196","","010"
北京天宝吉星房地产经纪有限公司","华梅影","","100088","北京市西城区裕中西里30号楼1001号","82073956","","010"
"北京华夏绿洲房地产经纪有限公司","文香花","","100029","北京市朝阳区望京西园三区322楼203室","84719796","","010"所有记录格式都是一样的现在想把这些记录改成:
中房鑫源(北京)房地产经纪有限公司,"北京市朝阳区东三环南路54号院4号住宅楼905室"……"65863388",邮编:"100022",王铮
"北京路易士房地产经纪有限公司","北京市朝阳区东三环中路42号201室"……"65819229",邮编:"100020","陆源"
"北京昌龙宏业房地产经纪有限公司","北京市朝阳区石佛营东里117号楼218室"……"85819196",邮编:"100025","刘万君"
北京天宝吉星房地产经纪有限公司","北京市西城区裕中西里30号楼1001号"……"82073956",邮编:"100088","华梅影"
"北京华夏绿洲房地产经纪有限公司",,"北京市朝阳区望京西园三区322楼203室"……"84719796",邮编:"100029""文香花"
"北京上古房地产经纪有限责任公司朝阳分公司","北京市朝阳区百子湾路1号211室"……"87778985",邮编:"100022","王蓓"
"北京佰家房地产经纪有限公司第三朝阳分公司","北京市朝阳区樱花西街18号(贵州大厦)1005室"……"64446823",邮编:"100029","董雪勇"请问,如何编写能达到目的啊?谢谢各位大侠。
有上万条如下数据,存为aaa.txt:中房鑫源(北京)房地产经纪有限公司,王铮","","100022","北京市朝阳区东三环南路54号院4号住宅楼905室","65863388","","010"
"北京路易士房地产经纪有限公司","陆源","","100020","北京市朝阳区东三环中路42号201室","65819229","","010"
"北京昌龙宏业房地产经纪有限公司","刘万君","","100025","北京市朝阳区石佛营东里117号楼218室","85819196","","010"
北京天宝吉星房地产经纪有限公司","华梅影","","100088","北京市西城区裕中西里30号楼1001号","82073956","","010"
"北京华夏绿洲房地产经纪有限公司","文香花","","100029","北京市朝阳区望京西园三区322楼203室","84719796","","010"所有记录格式都是一样的现在想把这些记录改成:
中房鑫源(北京)房地产经纪有限公司,"北京市朝阳区东三环南路54号院4号住宅楼905室"……"65863388",邮编:"100022",王铮
"北京路易士房地产经纪有限公司","北京市朝阳区东三环中路42号201室"……"65819229",邮编:"100020","陆源"
"北京昌龙宏业房地产经纪有限公司","北京市朝阳区石佛营东里117号楼218室"……"85819196",邮编:"100025","刘万君"
北京天宝吉星房地产经纪有限公司","北京市西城区裕中西里30号楼1001号"……"82073956",邮编:"100088","华梅影"
"北京华夏绿洲房地产经纪有限公司",,"北京市朝阳区望京西园三区322楼203室"……"84719796",邮编:"100029""文香花"
"北京上古房地产经纪有限责任公司朝阳分公司","北京市朝阳区百子湾路1号211室"……"87778985",邮编:"100022","王蓓"
"北京佰家房地产经纪有限公司第三朝阳分公司","北京市朝阳区樱花西街18号(贵州大厦)1005室"……"64446823",邮编:"100029","董雪勇"请问,如何编写能达到目的啊?谢谢各位大侠。
让我想想
哦哦哦。哦哦哦。
(lsftest望着楼主坏坏地笑嘿嘿)。
说的有理:
使用ACCESS
教她如何导入
然后再教一些简单的SQL查询语句
想怎么排就怎么排
做的又快又不至于让女朋友失业
就是 lsftest() 的方法
用a=split(字符串,",")