Foro teknikoak » MemoQ support »
How to change x% into %x, and , into .
Haria hasi duena: Zeki Güler
Zeki Güler
Zeki Güler  Identity Verified
Local time: 10:59
Bazkidea (2012)
Ingelesatik Turkierara
+ ...
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
Turkia
Local time: 11:59
Ingelesatik Turkierara
+ ...
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: 10:59
Bazkidea (2012)
Ingelesatik Turkierara
+ ...
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
Turkia
Local time: 11:59
Ingelesatik Turkierara
+ ...
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
Turkia
Local time: 11:59
Ingelesatik Turkierara
+ ...
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: 10:59
Bazkidea (2012)
Ingelesatik Turkierara
+ ...
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
Turkia
Local time: 11:59
Ingelesatik Turkierara
+ ...
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:

Foro honetako moderatzailea
Maya Gorgoshidze[Call to this topic]
Peter Zauner[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

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






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 »
Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »