in reply to Re: search date occurance from csv column
in thread search date occurance from csv column
My apology for making things not clear
I give you an example on what i want to achieve, let say today's date is 20140319 (based on format YYYYMMDD) i want to use this date to search the column date1 and date2 to find how many occurrence are there from each column and provide the total occurrences.
expected output is as following
column date1 = xx occurence
column date2 = xx occurence
__DATA__
input file
Student ID;date1;date2
13645722;20110327203202.0Z;20140211204731.0Z
14947374;20110327203202.0Z;20140220135320.0Z
15962660;20110327203156.0Z;20131106113716.0Z
17480884;20110327212821.0Z;20131211143804.0Z
13054554;20110327203141.0Z;20131205162959.0Z
|
|---|