- 论坛徽章:
- 0
|
导出一个csv文件(tst.csv)格式如下(仅列举2行,此文件数据量大):ORGNUMBER,ORGPATH,ORGNAME,SUBNODE,PNAME,GSHORTNAME,TDATE,SORGID
131025,0015000000/0015013737/,在册不在岗人员,0,分公司内部退养人员,内部退养人员,2015-11-02 00:00:36,[00150000000,0015013737]
52106532,0350000000/0065513737/,工程技术一分公司,1,公司工程技术公司工程技术一分公司机关,机关,2013-12-31 00:01:32,[0350000000,0065513737]
想转换为json格式,但是有些格式需要改变,主要是TDATE和SORGID列的类型变化
[{"ORGNUMBER":"131025","ORGPATH":"0015000000/0015013737/","ORGNAME":"在册不在岗人员","SUBNODE":"0","PNAME":"分公司内部退养人员","GSHORTNAME":"内部退养人员","TDATE":{"$date":"2015-11-02T00:00:36Z"},"SORGID":["00150000000","0015013737"]},
{"ORGNUMBER":"52106532","ORGPATH":"0350000000/0065513737/","ORGNAME":"工程技术一分公司","SUBNODE":"1","PNAME":"公司工程技术公司工程技术一分公司机关","GSHORTNAME":"机关","TDATE":{"$date":"2013-12-31T00:01:32Z"},"SORGID":["0350000000","0065513737"]}]
这个shell脚本可以实现么?我在用python处理,但是因为初学,写的不顺利,请大家个点建议,谢谢!
|
|