文本文件处理

1)Excel数据处理为SQL

  利用公式

  ="insert into tables values(seq_tables.nextval," &B:B& ",'" &C:C& "'," &D:D& "," &E:E& ",SYSDATE,STSDATE);"

2)linux利用Shell脚本 awk

cat 1.txt |awk -F"," '{print $1","$2",\""$3"\","$4","$5","$6","$7","$8}' > 2.txt

3)Vi中替换

 尚没研究出来