You may not need a RegEx if the string is aways the same pattern length wise.
In CF you could do <cfset str = "2005-01-01-05-00-00.000000"> <cfset newStr = Left(str, 10) & " " & Replace(Right(str, 15), "-", ":", "all")> <cfoutput> #str#<br /> #newStr# </cfoutput> Convert to Perl and you're away! Ade -----Original Message----- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 11 February 2005 21:55 To: CF-Talk Subject: OT: sed/perl regex 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 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 10/02/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:194385 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
