https://www.proz.com/forum/memoq_support/310160-how_to_change_x_into_x_and_into.html

How to change x% into %x, and , into .
Thread poster: Zeki Güler
Zeki Güler
Zeki Güler  Identity Verified
Local time: 23:49
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: 01:49
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: 23:49
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: 01:49
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: 01:49
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: 23:49
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: 01:49
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 .






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 »
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 »