How to change x% into %x, and , into .
Thread poster: Zeki Guler

Zeki Guler  Identity Verified
Ireland
Local time: 08:31
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,


Direct link Reply with quote
 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 11:31
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]


Direct link Reply with quote
 

Zeki Guler  Identity Verified
Ireland
Local time: 08:31
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]


Direct link Reply with quote
 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 11:31
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.


Direct link Reply with quote
 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 11:31
Member (2006)
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


Direct link Reply with quote
 

Zeki Guler  Identity Verified
Ireland
Local time: 08:31
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]


Direct link Reply with quote
 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 11:31
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


Direct link Reply with quote
 


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






SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »



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