Page 1 of 1

Converting Date Types

Posted: Fri Feb 06, 2009 8:31 am
by bolusan1
How can TextPipe help with converting a date of the type December 31st, 2008 to 12/31/2008?

Thanks,

Bola

Re: Converting Date Types

Posted: Fri Feb 06, 2009 2:14 pm
by DataMystic Support
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