Converting Date Types

[bolusan1]

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

Thanks,

Bola

[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