Talk About Network



Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Awk > Re: reformattin...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 4 Topic 2203 of 2236
Post > Topic >>

Re: reformatting date strings

by Seb <spluque@[EMAIL PROTECTED] > Mar 26, 2008 at 02:03 AM

On Wed, 26 Mar 2008 02:45:40 +0100,
Janis Papanagnou <Janis_Papanagnou@[EMAIL PROTECTED]
> wrote:

[...]

> You can write two gensub()s, where you replace the third
> [[:digit:]]{2} subpattern by 0[[:digit:]] and [1-9][[:digit:]], resp.,
> and add the respective century information before the replacement \\3.

Good idea, this seemed to work:


awk --re-interval '{
    sub(/ end,/, " ending,")
    if ($0 ~ /[[:digit:]]{2}\/[[:digit:]]{2}\/[[:digit:]]{2}/) {
       
$0=gensub(/([[:digit:]]{2})\/([[:digit:]]{2})\/([1-9])([[:digit:]])/,
            "19\\3\\4-\\1-\\2", "g")
        $0=gensub(/([[:digit:]]{2})\/([[:digit:]]{2})\/0([[:digit:]])/,
            "200\\3-\\1-\\2", "g")
    }
    print
}'

The regexps are a bit nasty though.  Thanks!


-- 
Seb




 4 Posts in Topic:
reformatting date strings
Seb <spluque@[EMAIL PR  2008-03-26 01:15:54 
Re: reformatting date strings
Janis Papanagnou <Jani  2008-03-26 02:45:40 
Re: reformatting date strings
Seb <spluque@[EMAIL PR  2008-03-26 02:03:40 
Re: reformatting date strings
Ed Morton <morton@[EMA  2008-03-28 17:08:02 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat May 17 2:37:47 CDT 2008.