Row Count in .csv file

Shell Programming and Scripting
1

Hi,
I have to find the count of rows starting with "E," in given a.csv file .

Sample Data File.

E,2333AED,A,MC3,25,31-MAY-18
E,2333AED,A,MC3,25,31-MAY-18
CYMC3  25AED            0000
E,2333CZK,A,MC3,25,31-MAY-18
CYMC3  25CZK            0000
E,2333EUR,A,MC3,25,31-MAY-18
E,2333EUR,A,MC3,25,31-MAY-18
E,2333EUR,A,MC3,25,31-MAY-18
 CYMC3  25EUR            0000
2

And what code have you written so far?

3

I have used below code

FileRowCount=`wc -l ${DATADIR}/${file} | awk '{print $1-1}'`

But this is counting all the records in the data file but I need to count only rows starting with "E," i.e detail records.

Thanks,
Prabhakar

4

How about

grep -c ^E file
6