Regular Expression problem

[jerijeri]

I have a csv file that has multiple dates in it.
they are in the format 1/17/2003

I want to convert to 2003-01-17

I've tried the following expressions:

match {.*}\/{.*}\/{.\d.\d.\d.\d},

replace with

\3-\2-\1, (this doesn't handle converting 1 to 01) but that's not the biggest problem.

What's happening is that {.*}\/{.*}\/{.\d.\d.\d.\d},

matches everything between 2 dates. I'm trying to specify that it must only match 4 digits followed by a comma. I can't find examples for that.

Thanks,

Jer

 

[jerijeri]

Found solution.

used {\d*}\/{\d*}\/{\d\d\d\d} to match the date.

That solved the problem.

Jer