i would do it like this: ($year,$month,$day,$hour,$minute,$seconds,$mils) = split($timedate,/\.\-/);
Then you can do whatever you want with it... Adam H On Fri, 11 Feb 2005 16:55:12 -0500, Rick Root <[EMAIL PROTECTED]> wrote: > Hey can someone write me a regex for use with sed that converts > 2005-01-01-05-00-00.000000 > > to > > 2005-01-01 05:00:00.000000 > > Muchas gracias... I'm converting some data files that I use to import > data into Oracle into files suitable for importing into SQL Server using > Bulk Insert, and SQL Server doesn't like the original format. > > - Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194412 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
