Shell Programming and Scripting

Hi

I would like to change certain columns in a file depending on the users choice of input and which columns they would like to change.

Here is my csv file:

Code:

 
SITEID,CELLID,Access Grant Blocks Reserved
1,1A,5
1,1B,2
1,1C,3
2,2A,7
2,2B,4
2,2C,0

If for example they would like to change the first record, third field, or add a fourth field, how can this be done? If they add a fourth field, they have to be allowed to enter values for the fourth field for all records.

This is what I have which inly allows them to change the third field by entering the cellid for the second field.

Code:

awk -F, -v id=$id -v paramval=$paramval -v paramname=$paramname -v oldfile=$dsxdir/$oldfile -v newfile=$dsxdir/$newfile '$2==id{$3=paramval}1' OFS="," $dsxdir/$oldfile > $dsxdir/$newfile

so " id " represents all the cellid's and "paramval" represents the values

I dont know how to manipulate this csv file.

Thank you for your help.

---------- Post updated at 08:22 AM ---------- Previous update was at 08:17 AM ----------

Can I simplify this please, suppose I want to only alter the first record, third field only if the user enters a value for paramname, and if they don't, this will remain as is. Remember, it means that no cellid will be entered in this instance.

your input here doesn't clear what user is presented with and what options are there for the user to change.

Do you really present the file as such without any hint and then user change it on his/her own?

If you can simulate some session that you would like to be done, it may help me to do so for you..

looks like you are doing the GSM Stuff

Regards,
busyboy.

Yip .. GSM - you do your stuff well ....

Okay well basically, it's just scripts thats I'm creating to automate some testing.

So there are scripts in one directory and csv files in another.

Here the help function tells the user their options:

Code:

function displayHelp()
{
echo ""
echo " Usage: ./Import_PlannedCELL.sh [ -c -d ]"
echo ""
echo " -c, --csvfile identified by the input file in csv format "
echo " -d, --dsxfile identified by the output file in dsx format "
echo " -h, --help identified by the help menu "
echo ""

}

so the user types ./script -h and is told how the script should be called .. that is

Code:

 
./script -c csvfilename -d dsxfilename

The script looks for the csv file from the specified directory and converts it to a dsxfile and stores it another directory. The user does not have to specify directory paths.

This part works fine.

Now I need the script to output the help function when nothing is entered when calling the script. It does so if any other character is entered except the ones specified in getopts ( c , d , h ):

Code:

 
while getopts " c: d: h " option
do
case $option in
c ) csvfile="$OPTARG";;
d ) dsxfile="$OPTARG";;
h ) displayHelp;exit;;
? ) displayHelp;exit;;
* ) displayHelp;exit;;

esac;
done

How do I get it to display help in this case:

Code:

./script

Thank you

---------- Post updated at 09:32 AM ---------- Previous update was at 09:29 AM ----------

Oooops, this is for my previous thread ... it still doesn't work .....

Sorry for the confusion.

To do add, change and delete to a csv file using a shell script is asking a lot. Why not use MS Excel and save the spreadsheet as a csv file on the unix system

Hi

It would have been nice if I could. Unfortunately, requirements stipulate that this is how it must be done.

I was able to change values by allowing the user to input the cellid, and then search for the cellid, and change the corresponding paramvalue

Code:

 
'$2==id{$3=paramval}1'

what if the user decides to change the parameter name?

so I need to cater for that.

I appreciate your reply, if this is impossible, I understand.

Which Operating System are you using (brand and release number)?

Hi. Can you give several examples of the input data for request modifications?

I think it is possible, at least the way I understand it