求助：文件处理：分割符

红狐狸

原文件举例如下：（注：db2数据库导出,只获得结果）
123，“111”，“abc，bbb，1"，""，77，“122”，

我想获得文件结果：
123，“111”，“abc，bbb，1"，""，77

用逗号与双引号做分割符，好像都有困难，请指点一下

liion631818

1. 
   
2. 
   
3. $ echo '123, "111", "aaa, bbb, 1", "", 77, "122",' | awk -F ',' -vOFS=',' '{$8=
   
4. ""}1'
   
5. 123, "111", "aaa, bbb, 1", "", 77,,
   

复制代码

到底是中文标点还是英文的啊

where27

awk -F, -v OFS="," '{NF=NF-2}1' file

红狐狸

到底是中文标点还是英文的啊
liion631818 发表于 2011-06-14 10:28

   非常感谢回复，标点是英文标点，我写的时候不小心。
能说明一下awk的
{$8=""}1' 这个用法吗？后边那个1，或则给点资料，万分感谢

liion631818

还是老表的好，后面的逗号也去掉了
awk的表达式是/pattern/{action},1等价于1{print $0}
print $0是awk默认行为

rwx_hc

楼主实际问题是字段中又含有分割符，导致不能正确处理字段
3楼的方法倒是科学点，但都没有真正意义解决问题

where27

回复 6# rwx_hc


    确实，楼主只给出了部分文本，我的不一定能通用

红狐狸

呵呵，原始文件比较复杂。
我只是举例
主要还是因为，引号中有逗号的问题，
我在想能否去除，双引号内的逗号

红狐狸

原文件的一行如下：
想获得  
^@^Et^@? 之前的数据，这玩意是不可见字符，

COMMODITY"888078750010001",,"888880000000129","Y","000008844","xxxxxxxxxJ92F","BANK OF CHI
NA,() ^M113 ZHONGSHAN ROAD,,,314001 ^Mjjjjjj","99999F0159/06",0,1,
"020001","N","0000049344","8888888J92F","BANK OF CHINA,() ^M113 ZH
ONGSHAN ROAD,,,314001 ^M33333","","","","","","","0000000110","AAAAA  CO.,LTD ",,,"0000027237","44444","BANK OF CHINA,O ^MVIA SANTA MARGHERITA ^M14/16,,,20121 MILANO","","","","","
                      ","EUR",+0000000270000.00,+0000000000000.00,"",+0000000270
000.00,"",+0000000000000.00,+0000000270000.00,+0000000000000.00,0,0,"IBL
",358,"002","358 DAYS AFTER SIGHT FOR 100 PCT ^MOF INVOICE VALUE.","100","000000
2163","BBBBB910","BANK OF CHINA,(888888 ^M321 FROAD,,,310003
HANGZHOU ",," S.P.A. VIA ^MLONATI 3,25124 bbbbbb,ITALY",2006021
7,"NOT ALLOWED","NOT ALLOWED","CHINA",20060324,"ITALIAN PORT","SHANGHAI,CHINA",2
0060303,"380","?^@^Et^@?COMMODITY:LONATI KNITTING MACHINE ^M1.BRAVO 1 4 X 168N
10SETS ^M2.BRAVO 1 4 X 144N^M3.BRAVO 6 4-1/2X96N^M+TOTAL QTY:20SETS^M+TOTAL VAL
UE:  EUR270000.00                               ^M+PRICE TERM:CIF SHANGHAI^M+PAC
KING:STANDARD PACKING^M"

yinyuemi

回复 8# 红狐狸


    把引号中的逗号换成空格:

1. $ echo '123, "111", "aaa, bbb, 1", "", 77, "122",' |awk -vRS='"[^"]*"' -vORS= '{gsub(","," ",RT);print $0RT}'
   
2. 123, "111", "aaa  bbb  1", "", 77, "122",

复制代码