How to change x% into %x, and , into .
Thread poster: Zeki Güler

Zeki Güler  Identity Verified
Ireland
Local time: 12:38
Member (2012)
English to Turkish
+ ...
Dec 23, 2016

Hi,

I've a document including several x% figures that I want to change into %x format all at once, rather than doing manually each time. I need to move all the numbers after the % symbol, i.e. 5%,> %5

Second, project also includes several figures with comma, i.e. 80,000 that I need to change into full stop, i.e. 80.000.

Thanks in advance,
Best,


 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 14:38
Member (2006)
English to Turkish
+ ...
regex Dec 26, 2016

Hi Zeki,

I am not a memoQ user but regex in find and replace should help.

Find: (\d{1,3}),(\d{3,})
Replace: $1.$2

This finds and replaces, e.g.
1,234 to 1.234
12,345 to 12.345
123,456 to 123.456

As for the percentage sign, I hope the following one works.

Find: (\d{1,2})%
Replace: %$1

This should find and replace, e.g.
1% to %1
99% to %99

For 99.9% or 99.99% you may need a different rule.



[Edited at 2016-12-27 01:03 GMT]


 

Zeki Güler  Identity Verified
Ireland
Local time: 12:38
Member (2012)
English to Turkish
+ ...
TOPIC STARTER
How about auto translation rule? Dec 26, 2016

Thank you Selçuk,

I am actually looking for a solution under auto-translation rules, which may be a bit more practical.
Do you have an idea how to do it?

Best,
Zeki

[Edited at 2016-12-26 22:08 GMT]


 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 14:38
Member (2006)
English to Turkish
+ ...
corrected versions for Auto-Translation Dec 26, 2016

Hi Zeki,

Create a new group for Turkish in Resource Console > Auto-translation rules.
Then add the following rules, first lines for auto translation rule and second line for replace rules.

(\d{1,2})%
%$1

(\d{1,2}).(\d{1,2})%
%$1,$2

(\d{1,3}),(\d{3,})
$1.$2

Finally, select this new group in Project > Settings > Autotranslation rules.


 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 14:38
Member (2006)
English to Turkish
+ ...
Autopick should help as well Dec 26, 2016

Translation Settings>Predictive Typing and Auto Pick > AutoPick

Number formaticon_smile.gif

It helps for decimal symbol only, not for the percentage sign.

Selcuk


 

Zeki Güler  Identity Verified
Ireland
Local time: 12:38
Member (2012)
English to Turkish
+ ...
TOPIC STARTER
It works indeed :) Dec 27, 2016

Dear Selçuk,

Indeed, those formulas work greaticon_smile.gif

Many Thanks

[Edited at 2016-12-27 01:15 GMT]


 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 14:38
Member (2006)
English to Turkish
+ ...
Online help file is good Dec 27, 2016

I am glad to hear that it worked. I don't use memoQ so I cannot test them. All credits should go to the writers of the help file.

Selcuk


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How to change x% into %x, and , into .

Advanced search






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search