cd /applmgr/custom/inbound/data for i in *.xls do echo $i newfile=$i.csv awk 'BEGIN { FS = "\t" OFS = "," } { $1 = $1 for (i = 1; i <= NF; i++) { if ($i == "") { $i = "null" } } print $0 }' $i > $newfile done
This blog is primarily intended for the beginners of Oracle Apps.Here, I would like to share some of my design and development work with Oracle Applications community.Feel Free to share your tips , tricks and scripts.Please contact me for "Oracle Apps Technical Trainings".
Tuesday, November 25, 2014
Script to Convert Excel tab to CSV
Labels:
Ready Scripts,
Shell Script
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment