Incredible.

This is exactly the kind of thing I was looking for. It doesn't handle AM/PM, which important in my case. Below is my hacked version that supports AM/PM by using "pp" to designate this. This creates an exceptional case in the script, because before only numbers were accepted, so instead of just \d, I'm now matching against \dPpAaMm 

# test like this: perl this_script.pl '02/04/2003 06:30 PM'
use strict;
sub prepareFormat {
    my $format = shift;

    # TODO: check that only valid characters appear in the format
    # The logic should be: for any character A-Z in the format string,
    #   die if it's not one of: Y M D h m s p  

    my ($i, @order) = 0;
    my $num_chars  = 'YMDhms';
    $format =~ s/([$num_chars]+)(\?)?/ $order[$i++] = substr($1,0,1); 
+'('.('\d' x length($1))."$2)"/ge;

    # use "p" for AM/PM
    $format =~ s/pp/ $order[$i++] = substr('p',0,1); "(AM|PM)"/e;


    $format = qr/^(?:$format)$/;
    return [$format, \@order];
}

sub parseDate {
    my ($format, $date) = @_;
    my @data = ($date =~ $format->[0])
        or return;
    my %result;
    for(my $i = 0; $i <= $#data; $i++) {
        $result{$format->[1]->[$i]} ||= $data[$i];
    }

    $result{h} += 12 if ($result{p} eq 'PM' and $result{h} != 12);
    $result{h} = 0   if ($result{p} eq 'AM' and $result{h} == 12);


    return map $result{$_}, qw(Y M D h m s);
}

#my $format = prepareFormat ('YYYY/MM/DD');
#my $format = prepareFormat ('YYYY-DD-MM|YYYY-DD-M|YYYY-D-MM|YYYY-D-M'
+);
#my $format = prepareFormat ('YYYY-DD?-MM?');
#my $format = prepareFormat ('YYYY-DD?-MM? hh?:mm?');
#my $format = prepareFormat ('YYYY-DD?-MM? hh?:mm?(?::ss?)?');
#my $format = prepareFormat ('YYYY-DD?-MM?(?: hh?:mm?(?::ss?)?)?');
my $format = prepareFormat ('MM/DD/YYYY hh:mm pp');

    my ($year, $month, $day, $hour, $min, $sec) = parseDate($format, $
+ARGV[0])
        or print "\tNot in the right format!\n" and exit;
    print "Year: $year, Month: $month, Day: $day, Hour: $hour, Min: $m
+in, Sec: $sec\n";

[download]

-mark

In reply to Re: Re: date format string -> Reg Ex solution by markjugg
in thread date format string -> Reg Ex solution by markjugg

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • 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:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.