Hi Ravindra,

Thank you for your response.

I have executed the latest code send by you :

Code:

awk 'NR==1 || NR==2{OFS=",";for(i=1;i<=NF;i++){Q=Q?Q OFS $i:$i}print Q;Q="";next} {for(i=1;i<=NF;i++){array[i]++}} END{for(j in array){A=A?A OFS array[j]:array[j]};print A}' OFS=,  RecountCountTest.csv> example_4.csv

The output data is giving correct for first 4 columns and the last 5 columns are not giving the correct record count, below are the source file and the target file(after i executed the above code) for your reference:

Source file:
First two are the headers and should not be in the count working good:




Target file after i executed the code provided by you:



for the columns NICKNAME count should be 0

Please help to resolve this issue, thanks for all your support.

Regards,
Kiran.

---------- Post updated at 07:52 AM ---------- Previous update was at 07:49 AM ----------

Hi Ravinder,

Here is the source data as per my previous reply if you did not able to see the data:

Source data:

STATUS USERID USERNAME FIRSTNAME NICKNAME MI LASTNAME SUFFIX TITLE
STATUS USERID Username FirstName Nickname MiddleName LastName Suffix Title
ACTIVE 80001001 itria1 Carlos Guillermo Itria
ACTIVE 80001002 lafournere1 Jean-Paul
ACTIVE 80001003 Wade Peter
ACTIVE 80001004 Olivier

Target Data: (after i executed the code provided by you

STATUS USERID USERNAME FIRSTNAME NICKNAME MI LASTNAME SUFFIX TITLE
STATUS USERID Username FirstName Nickname MiddleName LastName Suffix Title
4 4 2 4 4 4


Regards,
Kiran.