UNIX for Dummies Questions & Answers

 
#!/bin/bash
#---------------------------------------------------------------------------------------------------------------------- 
#This script allows the user to input the cellid and new parameter value, the old csv file and what the user 
#would like to name the new csv file. The changed data is then piped to the new file and ready for the import process
#
#./csv_file_change.sh -i -p -o -n
#
#-----------------------------------------------------------------------------------------------------------------------
id="$id"
paramval="$paramval"
oldfile="$oldfile"
newfile="$newfile"
function displayHelp()
{
echo ""
echo " Usage: csv_file_change [ -i -p -o -n ]"
echo ""
echo " -i, --id identified by the cellid "
echo " -p, --paramval identified by the new parameter value "
echo " -o, --oldfile identified by the name of the original file "
echo " -n, --newfile identified by the name of the new altered file "
echo " -h, --help identified by the help menu "
echo ""

}
while getopts " i: p: o: n: h " option
do
case $option in
i ) id="$OPTARG";;
p ) paramval="$OPTARG";;
o ) oldfile="$OPTARG";;
n ) newfile="$OPTARG";;
h ) displayHelp;exit;;
? ) displayHelp;exit;;



esac;
done
 
awk -F, -v id=$id -v paramval=$paramval -v oldfile=$oldfile -v newfile=$newfile '$2==id{$3=paramval}1' OFS="," $oldfile > $newfile

/C:\cygwin\var\local\dsx\csv

/C:\cygwin\var\local\dsx\output

/cygdrive/C/var/local/dsx/csv