Page 1 of 1

Changing the order of digits in date

Posted: Sat Jun 10, 2006 11:29 am
by kristopher
Hello,
I have text files with the date at the beginning of the every line in such format:
month (2 digits)-day(2 digits)-year(four digits)

example
02-22-2005

I want to change it to:
year-month-day

like:
2005-02-22

Is any way to do it with the TextPipe?

Thanx for the answer

Posted: Tue Jun 13, 2006 2:51 pm
by DataMystic Support
Very easy, use the EasyPattern search/replace

[ capture(2 digits), '-', capture(2 digits), '-', capture(4 digits) ]

Replace with

$3-$1-$2

Posted: Wed Jun 14, 2006 12:04 am
by kristopher
WOW
Indeed very easy

Thanx so much
:)