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