【求助】sed如何指定单引号中的内容

trubee

题目表达可能不是太到位。
比如我有一个文本文件test.txt，内容为：

1. 121        insert into user values('张三','112323198111112932','18611382732','4428991233299999')
   
2. 130        insert into user values('李四','22900220100228291X','13901028374','5187111192828888')
   
3. 140        insert into user values('王五','30100219491231829X','15810192837','6222020211102937776')

复制代码

最终替换成

121        insert into user values('张三','******************','18611382732','****************')
130        insert into user values('李四','******************','13901028374','****************')
140        insert into user values('王五','******************','15810192837','****************')

分别把身份证号与银行账号的列用*替换掉。想了好久没想出可行的方法

kernel69

来个perl吧

1. $ cat p.pl
   
2. #!/usr/bin/env perl
   
3. while(<DATA>) {
   
4.     @F = split/'/;
   
5.     print join "'", @F[0..2],"X" x length $F[3],@F[4..6],"X" x length $F[7],$F[8];
   
6. 
   
7. 
   
8. }
   
9. 
   
10. 
    
11. __DATA__
    
12. 121        insert into user values('张三','112323198111112932','18611382732','4428991233299999')
    
13. 130        insert into user values('李四','22900220100228291X','13901028374','5187111192828888')
    
14. 140        insert into user values('王五','30100219491231829X','15810192837','6222020211102937776')
    
15. $ ./p.pl
    
16. 121        insert into user values('张三','XXXXXXXXXXXXXXXXXX','18611382732','XXXXXXXXXXXXXXXX')
    
17. 130        insert into user values('李四','XXXXXXXXXXXXXXXXXX','13901028374','XXXXXXXXXXXXXXXX')
    
18. 140        insert into user values('王五','XXXXXXXXXXXXXXXXXX','15810192837','XXXXXXXXXXXXXXXXXXX')
    
19. $

复制代码

搞个命令行的perl,就因为是单引号'是分割符，怎么也出不来效果，还是对shell解析不太了解
@yestreenstars 怎么修改成命令行的?

1. pi@raspberrypi ~/perl $ cat data
   
2. 121        insert into user values('张三','112323198111112932','18611382732','4428991233299999')
   
3. 130        insert into user values('李四','22900220100228291X','13901028374','5187111192828888')
   
4. 140        insert into user values('王五','30100219491231829X','15810192837','6222020211102937776')
   
5. pi@raspberrypi ~/perl $ perl -F/\'/ -lane 'print join "\047", @F[0..2],"*" x length $F[3],@F[4..6],"*" x length $F[7],$F[8]' data
   
6. 121        insert into user values('张三','******************','18611382732','****************')
   
7. 130        insert into user values('李四','******************','13901028374','****************')
   
8. 140        insert into user values('王五','******************','15810192837','*******************')
   
9. pi@raspberrypi ~/perl $

复制代码

回复 1# trubee


   

nbrr

目测可以用awk
在手机上写的，可能不准确
awk -F, '{$2=\'*****\';$4=\'*****\'}'

Shell_HAT

回复 3# nbrr


    目测 \' 这样不行

yestreenstars

按LZ给的结果来的：

1. awk -F, -vOFS=',' '{$2="\047******************\047";$4="\047****************\047)"}1'

复制代码

根据数字的实际位数替换：

1. awk -F, -vOFS=',' 'gsub(/[^\047]/,"*",$2) && gsub(/[^\047)]/,"*",$4)'

复制代码

huang6894

一定要sed吗？
what about：

1. [huang@~]$ cat test
   
2. 121        insert into user values('..','112323198111112932','18611382732','4428991233299999')
   
3. 130        insert into user values('..','22900220100228291X','13901028374','5187111192828888')
   
4. 140        insert into user values('..','30100219491231829X','15810192837','6222020211102937776')
   
5. [huang@~]$ awk -F',' '{gsub(/[0-9A-Z]/,"*",$2);gsub(/[0-9A-Z]/,"*",$4)}1' test
   
6. 121        insert into user values('..' '******************' '18611382732' '****************')
   
7. 130        insert into user values('..' '******************' '13901028374' '****************')
   
8. 140        insert into user values('..' '******************' '15810192837' '*******************')
   

复制代码

yestreenstars

回复 2# kernel69
根据我写的awk命令改的：

1. perl -F, -lane '$F[1]=~s/[^\047]/*/g;$F[3]=~s/[^\047)]/*/g;print join ",",@F'

复制代码

xiaoshichao143

1. sed -i 's/[0-9]\{17\}[0-9xX]/******************/;s/[0-9]\{16,\}/****************/'

复制代码

bikong0411

awk -F, '{gsub(/[0-9]/,"*",$2);gsub(/[0-9]/,"*",$4);}1'  urfile