Help localizing dates

Question

Hi all! 
 I'm trying to localize the formatting of dates to follow a client's preferred style. They use the UN date format (day/month/year), for example: 18 June 2015. 
 Using Studio 2014 SP2, the closest I can get to that is 18 June, 2015. Is there a way around that? 
 Also, the settings let you change formatting for a specific language pair. Is there a way to change the Dates and Times settings so that they only apply to a specific TM? 
 thanks! 
 Becky

Paul · Accepted Answer

Hi Becky, 
 ok - I did a short video as I think this will help others too. Hope it's clear enough.

Paul · Answer

Hi Becky, 
 
That's because I should have given you this one: 
 
([1-3]\d)\sde\s(#Spanish_Months#)\sde\s(\d{4}) 
 
The one I gave you wouldn't pick up a zero as it's looking for 1-9 only, so the 1-3 in that instance certainly wouldn't work well at all! Sorry about that. 
 
Regards

Paul · Answer

Hi Becky, 
 
Can you give me an example of the source language formats and language?

Paul · Answer

Hi Becky, 
 
I don't think you can do this in a single expression because you'd need two different back references... one for the 1 in 01 and one for any double digit day that didn't start with 0. 
 
Why not just create two rules? That would be the easiest way to handle this I think. So search for these: 
 
0(\d)\sde\s(#Spanish_Months#)\sde\s(\d{4}) 
 
([1-9]{2})\sde\s(#Spanish_Months#)\sde\s(\d{4}) 
 
The first one will catch the ones starting with zero, and the second one will catch the rest. I didn't test it in Studio but I think this will work. 
 
Regards

Paul · Answer

Hi Becky, 
 ok - I tested the two rules I gave you and they work perfectly! 
 
 Are you sure you checked them both and gave them different names as they're different rules? 
 And yes, you could use [1-3] and that would be more precise and ensure that if anyone wrote the 91st January you'd find it straight away because the regexautosuggest would not work;-) 
 Your revised regex would find any day numbered from 10 to 999 though... probably not what you want either. I would check your implementation of the rules I gave you first. 
 Regards

Paul · Answer

Hi Becky,

I had some help from a real expert who showed me how to use named backreferences so that we can use one expression for multiple dates (with or without the zero)... so just sharing it here as it's so clever:

Search for:

(?:0(?<day>\d)|(?<day>[123]\d))\sde\s(?<month>#Spanish_Months#)\sde\s(?<year>\d{4})

Replace with:

${day} ${month} ${year}

Very smart!!

Trados Studio > 1. Trados Studio

Help localizing dates