Converting Date Types

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Converting Date Types

Postby 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?

Thanks,

Bola

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

Re: Converting Date Types

Postby 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

  $1/$2/$4
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 2 guests