if it were me, I would feed each entry to the date command with the proper formatting options for both the input and output.
-wes On Thu, Dec 13, 2012 at 2:28 PM, Rich Shepard <[email protected]>wrote: > I've a data file with rows that begin like this: > > '1995SBOIC020',1,'08/04/2004','Failed', > > and I want to change the date to ISO format, '2004-08-04'. I tried with > emacs regex to change the slash to a hyphen but without success. And I > don't > think regex will allow me to re-order the date numbers. > > Can SED be applied to this or is there a more elegant way to filter the > file so that all date fields are modified? I've tried a few things but > haven't seen the light of inspiriation that indicates I've done it > correctly. > > Thoughts? > > Rich > > _______________________________________________ > PLUG mailing list > [email protected] > http://lists.pdxlinux.org/mailman/listinfo/plug > _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
