救急！！

snowwolflake

请问如何把前面第一列去掉：
"9","402308222049","402308222049"
"10","402308222057","402308222057"
"99","403301000385","403301000385"
"100","403301001101","403301001101"
"759003","403332500459","403332500459"

rdcwayx

要快的话, 先用excel打开该文件，直接去除第一列，再存成txt文件即可。

davistar

1. 
   
2. awk 'BEGIN{OFS=FS=","}{$1="\b";print}' urfile
   

复制代码

snowwolflake

原帖由 davistar 于 2007-4-12 11:37 发表

1. 
   
2. awk 'BEGIN{OFS=FS=","}{$1="\b";print}' urfile
   

复制代码

我替换完后，怎么显示成这样：
^H,"403631200158","403631200158"
^H,"402624300827","402624300827"

yangkwch

vim的方法
:%s/"[0-9]*",//
不要用g参数就行了。

davistar

backspace产生的^H
bash下显示没事的 把$1="" 赋值成空就行了

atyu30

原帖由 davistar 于 2007-4-12 12:13 发表
backspace产生的^H
bash下显示没事的 把$1="" 赋值成空就行了

[root@ns4 ~]# awk 'BEGIN{OFS=FS=","}{$1="\b";print}' a.txt
,"402308222049","402308222049"
,"402308222057","402308222057"
,"403301000385","403301000385"
,"403301001101","403301001101"
,"403332500459","403332500459"
[root@ns4 ~]# awk 'BEGIN{OFS=FS=","}{$1="";print}' a.txt
,"402308222049","402308222049"
,"402308222057","402308222057"
,"403301000385","403301000385"
,"403301001101","403301001101"
,"403332500459","403332500459"

atyu30

如何去掉头部的 ","?

atyu30

原帖由 atyu30 于 2007-4-12 12:56 发表
如何去掉头部的 ","?

[quote]
[root@ns4 ~]# awk 'BEGIN{OFS=FS=","}{$1=" ";print $2,$3}' a.txt
"402308222049","402308222049"
"402308222057","402308222057"
"403301000385","403301000385"
"403301001101","403301001101"
"403332500459","403332500459"

[quote]
ok!

dream8888

原帖由 snowwolflake 于 2007-4-12 11:10 发表
请问如何把前面第一列去掉：
"9","402308222049","402308222049"
"10","402308222057","402308222057"
"99","403301000385" ...

sed 's/^[^,]*,//'  Filename