DataMystic

Posted: **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

Posted: **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

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

Replace with

  $1/$2/$4

Converting Date Types