[PLUG] Date Reformatting in Database Table

[Rich Shepard]

On Thu, 8 Oct 2009, Joe Pruett wrote:

> awk -F\| 'BEGIN{OFS="|"}{split($10, x,
> "/");$10=sprintf("%04d-%02d-%02d",x[3],x[2],x[1]);print}'

   Thanks, Joe. I'll save this for another day.

   I could have dug into my gray book on awk, but using the spreadsheet was
much faster ... for me. I just don't do enough awk or sed programming to be
proficient.

Much appreciated,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863