Number Formats in Studio 2022 - thousand separator

Hello,

How can I set a new number format (for the source language) that includes no thousand separator but a decimal separator only? It could ensure that a long number without any thousand separator is properly localised in the target segment.

Sandor

emoji
Parents Reply Children
  •  

    I don't know how to do this with one rule.  I'm not sure it can be... so you just simply do this:

    Screenshot of Trados Studio showing a list of rules for adding thousand separators with corresponding outputs.

    Add as many as you think you'll need.  Pain in the neck but once you've done it you have it forever and can reuse as much as you need.

    The toolkit is easier... search for this:

    \d(?=(?:\d{3})+(?!\d))

    Replace with this:

    $0,

    Then you have all your thousand separators in place.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 9:27 AM (GMT 0) on 29 Feb 2024]
  •  

    If it helps... it's quite quick to just edit this file:

    c:\Users\%username%\AppData\Roaming\Capybara.EditorPlugin.RegexMASProvider\Capybara.EditorPlugin.RegexMASProvider.settings.xml

    Here's the entries I set up in a couple of mins:

          <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>1</Description>
            <RegexPattern>\b(\d{1}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1.$2</ReplacePattern>
          </Entry>
          <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>2</Description>
            <RegexPattern>\b(\d{2}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1.$2</ReplacePattern>
          </Entry>
          <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>3</Description>
            <RegexPattern>\b(\d{3}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1.$2</ReplacePattern>
          </Entry>
          <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>4</Description>
            <RegexPattern>\b(\d{1})(\d{3}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1,$2.$3</ReplacePattern>
          </Entry>
          <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>5</Description>
            <RegexPattern>\b(\d{2})(\d{3}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1,$2.$3</ReplacePattern>
          </Entry>
          <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>6</Description>
            <RegexPattern>\b(\d{3})(\d{3}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1,$2.$3</ReplacePattern>
          </Entry>
          <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>7</Description>
            <RegexPattern>\b(\d{1})(\d{3})(\d{3}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1,$2,$3.$4</ReplacePattern>
          </Entry>
                <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>8</Description>
            <RegexPattern>\b(\d{2})(\d{3})(\d{3}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1,$2,$3.$4</ReplacePattern>
          </Entry>
                <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>9</Description>
            <RegexPattern>\b(\d{3})(\d{3})(\d{3}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1,$2,$3.$4</ReplacePattern>
          </Entry>
                <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>10</Description>
            <RegexPattern>\b(\d{1})(\d{3})(\d{3})(\d{3}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1,$2,$3,$4.$5</ReplacePattern>
          </Entry>
                <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>11</Description>
            <RegexPattern>\b(\d{2})(\d{3})(\d{3})(\d{3}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1,$2,$3,$4.$5</ReplacePattern>
          </Entry>
                <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>12</Description>
            <RegexPattern>\b(\d{1})(\d{3})(\d{3})(\d{3})(\d{3}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1,$2,$3,$4,$5.$6</ReplacePattern>
          </Entry>
                <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>13</Description>
            <RegexPattern>\b(\d{2})(\d{3})(\d{3})(\d{3})(\d{3}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1,$2,$3,$4,$5.$6</ReplacePattern>
          </Entry>
                <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>14</Description>
            <RegexPattern>\b(\d{3})(\d{3})(\d{3})(\d{3})(\d{3}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1,$2,$3,$4,$5.$6</ReplacePattern>
          </Entry>
                <Entry>
            <IsEnabled>true</IsEnabled>
            <Description>15</Description>
            <RegexPattern>\b(\d{1})(\d{3})(\d{3})(\d{3})(\d{3})(\d{3}),(\d+)\b</RegexPattern>
            <ReplacePattern>$1,$2,$3,$4,$5,$6.$7</ReplacePattern>
          </Entry>

    Works nicely :-)

    Trados Studio screenshot showing a number pattern in the source text '3456775543566,45' and the corresponding regex replacement result '3,456,775,543,566.45' highlighted in blue.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub



    Generated Image Alt-Text
    [edited by: Trados AI at 9:27 AM (GMT 0) on 29 Feb 2024]