posted 22 years ago
I am trying to read from a file and then write to a file.
The input file looks like following :
07200608240190200105,WA07MA44,K
07200608340190200105,WA07MA37,K
07200608240190200105,WA07MA34_P2, K
07200608240190200105,WA07MA34_P1,K
07200608440190200105,WA07MA32,K
07200608340190200105,WA07MA31,K
07200608640190200105,WA07MA30_P2,K
07200608240190200105,WA07MA30_P2,K
07200608540190200105,WA07MA28_P2,K
07200608840190200105,WA07MA28_P1,K
07200608240190200105,WA07MA20_P2,K
07200608240190200105,WA07MA20_P2,K
07200608340190200105,WA07MA18,K
The Output should be :
The total Number of records in the input file : < the total number of records > -- In our case it should be 13
The number of unique values in the first column : This case it should be 6
The number of unique values in the secind column : This case it should be 11
I am cluseless about how to achieve this.Anybody please help me with the idea and/or code.
Thanks,
Chris.