如何批量追加日期

jiaoli

文本如下：

"张三",37559924,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
"里斯",37530215,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
"王五",37464466,78.19,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
"赵六",37490489,402.10,27000.00,0.00,157000.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,22750.00,


如何在第二个字段后面批量追加日期？日期格式20100823

如何把文本每行最后那个，去掉？


处理后格式如下

"张三",37559924,20100823,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00
"里斯",37530215,20100823,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00
"王五",37464466,20100823,78.19,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00
"赵六",37490489,20100823,402.10,27000.00,0.00,157000.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,22750.00


谢谢！

ly5066113

sed 's/,/,20100823,/2;s/,$//' urfile

BangBull

1. sed 's/\([^,]\+,[^,]\+,\)/&20100823,/' urfile

复制代码

BangBull

回复 2# ly5066113

1. 's/,/,20100823,/2‘

复制代码

这个为什么 最后面会多出一点呢 , 不是只替换第二个 , 吗～！

jiaoli

谢谢，试一下！

rdcwayx

awk -F, '{printf "%s,%d,%d,",$1,$2,"20100823,";for (i=3;i
99超人 发表于 2010-08-23 09:05

民工的这个好像搞的有些复杂了。

1. awk -F , -v date=$(date +%Y%m%d) '{$2=$2 FS date ; gsub(/,$/,"")}1' OFS=, urfile

复制代码

如果不需要导入日期，可以更短：

1. awk -F , '{$2=$2 ",20100823" ; gsub(/,$/,"")}1' OFS=, urfile

复制代码

greysky-zfj

回复 1# jiaoli


    sed  's/,/,20080103,/;s/,$//'p urfile

BangBull

回复 8# greysky-zfj


    不知这个是否执行过