Hello Gentlemen,

Finding difficulties to play with my Input files . Your guidance will certainly help as always.
After converting to csv file from XLSM file, I am getting some extra ""(double quote) characters which I want to terminate inside shell script and process it further.

Ex:One Single Line post converting to CSV file

Code:

0),0,,,extW_2x32_2x32,targetServer_500,,,,,,command execution server,root,extW_2x32_2x32_Multi=200_cont=1_1exist=500use=100exec=openssl to=10,60,"./call_command_local.sh  -c extW_2x32_2x32  -t targetServer_500  -X 1  -N 1  -D 2 -a 100 wac sample exec ""\""hostname=XXXXX commandline='timeout 10 openssl  speed -multi 2 ; exit 0'\"""" ",1,1,0,200,1,1,"32G, t2.2xlarge","32G, t2.2xlarge",5000,,500,100,openssl ,10,timeout 10 openssl  speed -multi 2 ; exit 0,,160,30,161,4.183333333,42.55,0,

First Step:
I want to extract only the above highlighted red color and run it 3 consecutive times inside shell script.
I tried something like below but still not able to figure out how to remove the trailing extra "(Double quotes) which generated unnecessarily while converting to CSV

Code:

awk -F, '{gsub(/^"/, "", $16); print $16}' AWS_V1.7.5.csv 

Second Step:
Run 3 times the above parsed string in shell script. At the same time record the Execution time to use laterEx: ${start_time} = 1st Execution
${end_time} = 3rd Execution

Code:

seq 3 | xargs -I -- (Pass the above whole shell script along with parameters)

The above command will generate 3 XXX.csv Files with Date time. Format is as shown below. Which needs to process further for next command
CSV File Ex:

Code:

exec=1_host_count=100_dup=4_NameTag=targetServer_500_20171122112108.csv

Third Step:
Run the below command once the above commands executed and generated above XXX.CSV files are the input to below command

Code:

java -classpath ./:${CLASSPATH}  execGetResult XXX.csv

I need to run it for 3 times for each CSV file generated in step 2.
It will give me output 3 out files as below.
Ex:

Code:

out.exec=1_host_count=100_dup=4_NameTag=targetServer_500_20171122112108.csv

Fourth Step :
Run below commands

Code:

./AWS_get_statistics.sh -t Manager -s ${start_time} -e ${end_time}

${start_time} = ${start_time}-1 min
${end_time} = ${end_time}+ 1 min

Fifth Step :
tar cvf AWS.${date}.tar ./AWS

Thanks in advance
PD