MemoQ 2014 R2 auto-translation rules Thread poster: Châu Nguyễn
|
|---|
Châu Nguyễn 
Vietnam
Local time: 13:08
Member (2012)
English to Vietnamese
+ ...
Hi, i'm kinda new to MemoQ auto-translation rules.
Could any one help me to write an expression to convert a date string from format 'dd/mm/yyyy' to 'mmmm dd, yyyy'? e.g: 01/01/2014 => January 01, 2014.
I tried the following:
- Since the month would be a number, I created a translation pairs custom list #month# with source is number from 01-12 and target is January-December.
- In the Auto-translation rules I created the following auto-translation rule... See more Hi, i'm kinda new to MemoQ auto-translation rules.
Could any one help me to write an expression to convert a date string from format 'dd/mm/yyyy' to 'mmmm dd, yyyy'? e.g: 01/01/2014 => January 01, 2014.
I tried the following:
- Since the month would be a number, I created a translation pairs custom list #month# with source is number from 01-12 and target is January-December.
- In the Auto-translation rules I created the following auto-translation rules: '(\d)/(#month#)/(\d)' and Replace order rules: '$2 $1, $3'.
- The result: 01/01/2014 => 01nuary 01, 2014 | 01/02/2014 => 02bruary 01, 2014.
I wonder why is there always two digit that replace the first 2 characters of the $2. If I put extra spaces in front it would show 01 January 01, 2014 | 02 February 01, 2014.
I appreciate all your help.
Thanks. ▲ Collapse
| | | | | RegEx needs fixing | Aug 3, 2015 |
Hi,
Try \d+ instead of \d in both instances.
Edit: I now see that these rules behave one way in the preview and another way in the editor. Where are you experiencing this?
[Edited at 2015-08-03 14:58 GMT]
| | | | Châu Nguyễn
Vietnam
Local time: 13:08
Member (2012)
English to Vietnamese
+ ...
TOPIC STARTER | I did not check in the editor | Aug 4, 2015 |
I only preview my regex. Since it did not turn out as I expected, I did not use it in editor mode. Now that you mentioned it, I will try and see what happened.
I found the solution
To convert from dd/mm/yyyy to mmm dd, yyyy the auto-translation rule should be (\d\d)/(#month#)/(\d\d\d\d) and the replace order rule should be $2 $1, $3.
[Edited at 2015-08-04 02:54 GMT]
More notes:
- There is a different between 1 and 01.... See more I only preview my regex. Since it did not turn out as I expected, I did not use it in editor mode. Now that you mentioned it, I will try and see what happened.
I found the solution
To convert from dd/mm/yyyy to mmm dd, yyyy the auto-translation rule should be (\d\d)/(#month#)/(\d\d\d\d) and the replace order rule should be $2 $1, $3.
[Edited at 2015-08-04 02:54 GMT]
More notes:
- There is a different between 1 and 01. So in the above example if you want to translate 1 or 01 into January, You have to create 2 different list items in the Translation pairs. i.e. 1 - January and 01 - January. The same for other months.
- Different translation rules must be set to cover all possible of the date and time format as in my above example.
+ 05/01/1989 : (\d\d)/(#month#)/(\d\d\d\d)
+ 5/1/1989: (\d)/(#month#)/(\d\d\d\d)
+ 5/1/89: (\d)/(#month#)/(\d\d)
[Edited at 2015-08-04 03:29 GMT] ▲ Collapse
| | | | | If you need something simpler | Aug 4, 2015 |
I'm glad you found a solution. If you want to use just one rule for all cases you mention and similar ones, this should work: (\d+)/(#month#)/(\d+)
| | |
|
|
|
Châu Nguyễn
Vietnam
Local time: 13:08
Member (2012)
English to Vietnamese
+ ...
TOPIC STARTER
Manuel Arcedillo wrote:
I'm glad you found a solution. If you want to use just one rule for all cases you mention and similar ones, this should work: (\d+)/(#month#)/(\d+)
Thank you,
I didn't understand your suggestion at first. I've just read through the documentation and kinda understand it now.
| | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » MemoQ 2014 R2 auto-translation rules | Anycount & Translation Office 3000 | Translation Office 3000
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.
More info » |
| | Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
