小菜鸟遇到 一个 sed 匹配问题

summersunboy

原文件(2.txt)是这样的：

1. ,0,好,a
   
2. ,1,好,b
   
3. ,2,学,c
   
4. ,3,习,d
   
5. ,4,天,e
   
6. ,5,天,f
   
7. ,6,向,g
   
8. ,7,上,h

复制代码

处理后要达到的效果是这样：

1. INSERT (0,"好",a");
   
2. INSERT (1,"好",b");
   
3. INSERT (2,"学","c");
   
4. INSERT (3,"习","d");
   
5. INSERT (4,"天",e");
   
6. INSERT (5,"天",f");
   
7. INSERT (6,"向",g");
   
8. INSERT (7,"上",h);

复制代码

我编写的脚本如下：

1. #!/bin/bash
   
2. processTxt()
   
3. {
   
4. #匹配,开头的行
   
5. #将第一个 , 替换成 INSERT (
   
6. #并在结尾补上 );
   
7. #将第二个 , 替换成 ,"
   
8. #将第三个 , 替换成 ","  ## 我这儿遇到问题了
   
9. #我在区分 第二个与第三个, 时是以 ,前的字符不为数字区分的
   
10. #可是有的字符成功匹配 有的不成功
    
11. sed -i "/^,/{
    
12.         s/^,/INSERT \(/
    
13.         s/\r/\"\);\r/
    
14.         s/,/,\"/
    
15.     s/\([^\x30-\x39]\),/\1\",\"/
    
16.         }" $1
    
17.    # s/\([^0-9]\),/\1\",\"/
    
18. }
    
19. 
    
20. #开始处理
    
21. rm -rf 1.txt
    
22. cp 2.txt 1.txt
    
23. echo "process 1.txt"
    
24. processTxt 1.txt
    
25. echo "end process"

复制代码

处理后的结果(1.txt)有的匹配成功有的不成功:

1. INSERT (0,"好,a");
   
2. INSERT (1,"好,b");
   
3. INSERT (2,"学","c");
   
4. INSERT (3,"习","d");
   
5. INSERT (4,"天,e");
   
6. INSERT (5,"天,f");
   
7. INSERT (6,"向,g");
   
8. INSERT (7,"上,h);

复制代码

只有 学 和 习 这两个匹配成功了，其它的都不行，这是为什么呢？恳请各位前辈多多指教，先谢过各位了！

bbgg1983

1. sed -r 's/,(.+),(.+),(.+)/INSERT ("\1","\2","\3");/' 2.txt

复制代码

bbgg1983

哇，看花眼了，写的不对

iori809

回复 1# summersunboy


    最后一个为啥是11呢？括号少一个？是笔误了还是就是这需求？

nomyself

1. 
   
2. awk -F ',' '{print "INSERT","("$2",\""$3"\","$4"\");"}' txt
   

复制代码

expert1

1. # echo ,7,上,h|awk  -F "," '{print "INSERT (,"$2",""\042"$3"\042"",""\042"$4"\42"");"}'  
   
2. INSERT (,7,"上","h");

复制代码

summersunboy

不好意思，写错了。现己改正。

expert1

SO EASY!!!!

1. ~# echo ",0,好,a
   
2. ,1,好,b
   
3. ,2,学,c
   
4. ,3,习,d
   
5. ,4,天,e
   
6. ,5,天,f
   
7. ,6,向,g
   
8. ,7,上,h"|awk  -F "," '{print "INSERT (,"$2",""\042"$3"\042"",""\042"$4"\42"");"}'
   
9. INSERT (,0,"好","a");
   
10. INSERT (,1,"好","b");
    
11. INSERT (,2,"学","c");
    
12. INSERT (,3,"习","d");
    
13. INSERT (,4,"天","e");
    
14. INSERT (,5,"天","f");
    
15. INSERT (,6,"向","g");
    
16. INSERT (,7,"上","h");

复制代码

再挣2分。

ly5066113

sed  判断第几个：

echo '1,2,3,4' | sed 's/,/@/'   # 1是默认值，可以不写
echo '1,2,3,4' | sed 's/,/@/2'
echo '1,2,3,4' | sed 's/,/@/3'

summersunboy

echo ",0,好,a
,1,好,b
,2,学,c
,3,习,d
,4,天,e
,5,天,f
,6,向,g
,7,上,h"|awk  -F "," '{print "INSERT ("$2",""\042"$3"\042"",""\042"$4"\42"");"}'
原来用awk这么简单。
谢谢 expert1
以及iori809 (梦呆呆) 、nomyself 、bbgg1983 (朕本布衣) ，谢谢大家