Shell Programming and Scripting

Hi,

I'm new to shell scripting and require your help in achieving the requirement.

I have a data file which stores organization name as one of the column data in a csv data file.

Organization name stored in data file is: Canadian OU CAD

Sample Data file:

1,5,4,5,,
,,,,Canadian OU CAD,Canada
,,,,Canadian OU CAD,Australia
,,,,Canadian OU CAD,Japan


I need to know the count of the occurences of the name Canadian OU CAD from the data file.

I'm getting the organization name that needs to be searched as a parameter to the shell script. Below is the code that i have written:

organization_name=$1

echo "org name = " $organization_name

c=`echo $organization_name | sed 's/^/"/' | sed 's/$/"/'`
echo " c = " $c

b=`grep -c ${c} $HOME/TESTING5.csv`

echo $b


When i try to run the above script it throws error:

org name = Canadian OU CAD
c = "Canadian OU CAD"
grep: can't open Canadian
grep: can't open OU
grep: can't open CAD"


In the above case, i expect the output to be 3 instead of the error.

The bold is wrong

Code:

b=`grep -c \"${c}\" $HOME/TESTING5.csv`

I think it should work.

Code:

an easier way

awk -F"," '{a[$4]++ } END{for (i in a) {print i,a[i]}}'

you can use this code to count anything .
you just need to know the field number of the string that you want to count.. in this case it is field number 4
BR

Hi,

I corrected the syntax to b=`grep -c \"${c}\" $HOME/TESTING5.csv`

but still the same issue. I'm still getting the below error while trying to execute the script.

org name = Canadian OU CAD
c = "Canadian OU CAD"
grep: can't open Canadian
grep: can't open OU
grep: can't open CAD""
/export/home/appwdev/TESTING5.csv:0

Code:

string="Canadian OU CAD"
awk -v v="$string" 'BEGIN{FS=","}$5 ~ v{ d++}END{ print "total: "d}' file

Absolutely my mistake...
it should be '${c}'

Now it returns 0 count after modifying the syntax to '${c}'

org name = Canadian OU CAD
c = "Canadian OU CAD"
0