Converting Date Types

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Post Reply
Posts: 2
Joined: Wed Dec 10, 2008 5:42 am

Converting Date Types

Post by bolusan1 » Fri Feb 06, 2009 8:31 am

How can TextPipe help with converting a date of the type December 31st, 2008 to 12/31/2008?



User avatar
DataMystic Support
Site Admin
Posts: 2235
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Re: Converting Date Types

Post by DataMystic Support » Fri Feb 06, 2009 2:14 pm

You need a Filters\Replace\Search/replace list to convert the months to a 2 digit number.

Then use a perl pattern

Code: Select all

  (\d{2}) (\d{2})(st|rd|nd), (\d{4})
Replace with

Code: Select all


Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads

Post Reply