I used Date::Calc as someone suggested to get the business days.
#!/usr/bin/perl
use strict;
use Date::Calc qw(:all);
while( <DATA> ) {
my $old_data = $_;
my ($old_date) = $_ =~ /^(\d{8})\d+,.*/;
my ($year, $month, $day) = $old_date =~ /(\d{4})(\d{2})(\d{2})/;
my $dow = Day_of_Week( $year, $month, $day );
print "$old_data" if ( $dow >= 1 && $dow <= 5 );
}
__DATA__
2009030822,3558,1.68
2009030823,6385,5.47
2009030900,7485,1.82
2009030901,8563,4.35
2009031322,8860,3.68
2009031323,39224,14.16
2009031400,34553,7.34
2009031401,7353,5.74
2009032107,8860,3.68
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
| |
For: |
|
Use: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.