文华财经导出的文件删除标题行、插入新行

文华财经导出的文件删除标题行、插入新行

目录

文华财经导出的文件删除标题行、插入新行

删除标题行

插入行

同时删除标题行、插入新行

macos安装gnu-sed

用gsed代替sed

一次性处理当前目录及子目录下的所有.csv文件

有标题行 

无标题行

15分钟线：沪金2102.csv

---

删除标题行

sed -i '1d' filename.csv

插入行

sed -i '1i\Date,Time,Open,Max,Min,Close,TradeNumber,HolderNumber,Average' filename.csv

同时删除标题行、插入新行

sed -i '1d;2i\Date,Time,Open,Max,Min,Close,TradeNumber,HolderNumber,Average' filename.csv

macos安装gnu-sed

brew install gnu-sed

用gsed代替sed

gsed -i '1d;2i\Date,Time,Open,Max,Min,Close,TradeNumber,HolderNumber,Average' filename.csv

一次性处理当前目录及子目录下的所有.csv文件

有标题行 

find . -name "*.csv" -exec gsed -i '1d;2i\Date,Time,Open,Max,Min,Close,TradeNumber,HolderNumber,Average' {} \;

无标题行

find . -name "*.csv" -exec gsed -i '1i\Date,Time,Open,Max,Min,Close,TradeNumber,HolderNumber,Average' {} \;

15分钟线：沪金2102.csv

Date,Time,Open,Max,Min,Close,TradeNumber,HolderNumber,Average
2020/04/24,09:30,382.6600,383.2000,382.6600,383.2000,10.0000,497.0000,383.0920
2020/04/24,10:00,383.0400,383.9000,383.0400,383.9000,8.0000,499.0000,383.4700
2020/04/24,10:30,383.5000,383.7200,383.4800,383.7200,9.0000,497.0000,383.5489
2020/04/24,10:45,383.4800,383.4800,383.4400,383.4400,2.0000,496.0000,383.4600
2020/04/24,11:00,383.3800,383.3800,383.3200,383.3200,2.0000,496.0000,383.3500
2020/04/24,11:15,383.0200,383.0200,382.9400,382.9400,3.0000,497.0000,382.9666
2020/04/24,13:30,383.3400,383.4800,383.1200,383.1200,6.0000,501.0000,383.2767
2020/04/24,14:00,383.4200,383.4200,383.4000,383.4000,3.0000,501.0000,383.4066
2020/04/24,14:15,383.8000,384.7000,383.8000,384.4200,26.0000,513.0000,384.2577
2020/04/24,14:30,384.8000,385.3600,384.8000,385.0400,13.0000,518.0000,385.0585