- 论坛徽章:
- 0
|
$ cat name.txt
zhangsan
lisi
wangwu
houliu
liuqi
zhaojiu
....
$ cat 01.txt
zhangsan 3500.25
lisi 3621.52
wangwu 2995.41
houliu 3802.05
liuqi 2812.88
....
$ cat 02.txt
zhangsan 2967.32
lisi 2916.33
houliu 3217.09
liuqi 3501.48
....
$ cat 03.txt
zhangsan 3456.78
lisi 2926.22
wangwu 3027.66
liuqi 2298.34
....
需求:按name.txt中的名字将每个月的金额(01.txt、02.txt .... )合成一个文件(字段分隔符为逗号)如下:
name,01,02,03
zhangsan,3500.25,2967.32,3456.78
lisi,3621.52,2916.33,2926.22
wangwu,2995.41,,3027.66
houliu,3802.05,3217.09,
liuqi,2812.88,3501.48,2298.34
zhaojiu,,,
....
其中“wangwu”和“houliu”因有字段为空值而与其它人的信息不同。
请教如何简明而高效地实现?谢谢!
|
|