Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re^2: search date occurance from csv column

by anakin30 (Acolyte)
on Mar 19, 2014 at 03:42 UTC ( #1078891=note: print w/ replies, xml ) Need Help??


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


Comment on Re^2: search date occurance from csv column

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1078891]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (5)
As of 2014-11-27 01:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (178 votes), past polls