Regex and dates in Studio

Question

Hello, 
 I am trying to change American format dates (ie: 12/15/23) to a particular French format (ie: 15.12.2023) (after I copied source to segment as all these are names of securities). 
 Obviously, doing this (the intuitive thing, for me anyway!) 
 
 But this doesn't work. Can you help me please? 
 Kind regards 
 Corinne

Paul · Accepted Answer

Hi Corinne Le Gallic 
 You're close... just using some incorrect syntax for the search. Try this: 
 Search for: 
 (\d{1,})/(\d{2})/(\d{2}) 
 Replace with: 
 $2.$1.20$3 
 I'm sure there are other solutions, but this quick and dirty solution may be helpful.

Trados Studio > 5. Regex and XPath

Regex and dates in Studio

Top Replies