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}'Well, Joe! That is super slick. Turns out the spreadsheet copied the value rather than the formula so all dates were the same. I started over and used your awk script. Instant success. Many grasses, Rich _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
