本帖最后由 yinyuemi 于 2011-08-12 03:00 编辑
回复 41# hfvbc - echo '1,"nihao,shia,"shi","hiscihe",3,8
- 1,"nihao,shma",shi","hiscihe",3,8
- 1,"nihao,"shma",shi","hiscihe",3,8
- 1,"nihao,s"hma",shi","hiscihe",3,8
- 2,1,"nihao,shma",shi",2,5,6,"hiscihe",3,8,9' |\
- awk -F, -v t="#" '{
- printf $1;
- for(i=2;i<=NF;i++){
- if(j==0){
- if($i~/^\"[a-zA-Z]+$/){sub("\"","",$i);printf t $i",";j++}
- else{gsub("\"","",$i);printf t $i}
- }else{
- if($i~/[a-zA-Z ]+\"$/&&$(i+1)~/^\"[a-zA-Z]|[0-9]/){sub("\"$","",$i);printf $i;j--}
- else {printf $i","}
- }
- }
- print ""}'
- 1#nihao,shia,"shi#hiscihe#3#8
- 1#nihao,shma",shi#hiscihe#3#8
- 1#nihao,"shma",shi#hiscihe#3#8
- 1#nihao,s"hma",shi#hiscihe#3#8
- 2#1#nihao,shma",shi#2#5#6#hiscihe#3#8#9
复制代码 |