文本文件处理
2011-02-12 13:59 hanwesley 阅读(191) 评论(0) 编辑 收藏 举报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中替换
尚没研究出来
