How to change x% into %x, and , into .
Thread poster: Zeki Güler
Zeki Güler
Zeki Güler  Identity Verified
Local time: 07:12
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
Selcuk Akyuz  Identity Verified
Türkiye
Local time: 09:12
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 m
... See more
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]
Collapse


 
Zeki Güler
Zeki Güler  Identity Verified
Local time: 07:12
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
Selcuk Akyuz  Identity Verified
Türkiye
Local time: 09:12
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
Selcuk Akyuz  Identity Verified
Türkiye
Local time: 09:12
English to Turkish
+ ...
Autopick should help as well Dec 26, 2016

Translation Settings>Predictive Typing and Auto Pick > AutoPick

Number format

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

Selcuk


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

Dear Selçuk,

Indeed, those formulas work great

Many Thanks

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


 
Selcuk Akyuz
Selcuk Akyuz  Identity Verified
Türkiye
Local time: 09:12
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 .






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »