RT, excel文件中包含了软回车,转换成csv后有存在软回车,导致形成多行,并用" 包含,数据如下
Prctnr Cnum Id,Asgnmt Id,Strt Dt,End Dt,Cre T,Asgnmt Catgry Cd,Project Name,Client Name,Rem Stat Txt
060069672,"10,636,278.",10/08/13,11/30/13,09/25/13 03:09 AM,BIL,"255U-1B2M74J, ICBC PF,C.02420.002",ICBC,
060069672,"10,846,782.",11/14/13,12/13/13,11/13/13 04:07 AM,BIL,"WM-FZUCP74, ICBC PF PCR",INDUSTRIAL AND COMMERCIAL BANK OF,"C.02420.004, WM-FZUCP74,ICBC PF PCR
ICBC PF PCR
OS fulfilled and closed"
060112672,"10,135,402.",05/06/13,12/31/13,05/20/13 10:10 AM,PIL,CIS Prototype development,YOKOHAMA CITY UNIVERSITY HOSPITAL,CN-13-04243
有高手能用sed 处理一下 ,去掉这个软回车,目标格式如下:
Prctnr Cnum Id,Asgnmt Id,Strt Dt,End Dt,Cre T,Asgnmt Catgry Cd,Project Name,Client Name,Rem Stat Txt
060069672,"10,636,278.",10/08/13,11/30/13,09/25/13 03:09 AM,BIL,"255U-1B2M74J, ICBC PF,C.02420.002",ICBC,
060069672,"10,846,782.",11/14/13,12/13/13,11/13/13 04:07 AM,BIL,"WM-FZUCP74, ICBC PF PCR",INDUSTRIAL AND COMMERCIAL BANK OF,"C.02420.004, WM-FZUCP74,ICBC PF PCR ICBC PF PCR OS fulfilled and closed"
060112672,"10,135,402.",05/06/13,12/31/13,05/20/13 10:10 AM,PIL,CIS Prototype development,YOKOHAMA CITY UNIVERSITY HOSPITAL,CN-13-04243
总共合并为4行, 第一行是prc开头的column name, 下面3行是数据 |