: Using grep to finding long digit series and inserting thin spaces into them On my page i have a table with over 500 rows, in it one column where all cells contain a different numbers, such

Posted in: #AdobeIndesign #Grep #IndesignScripting

On my page i have a table with over 500 rows, in it one column where all cells contain a different numbers, such as 55123, 666000, 3000 and 1459000 (figures for sums of money). I would need to insert thin spaces in the numbers for them to be easier to read, according to the following scheme:

Seven digits in a row is changed to:
d ddd ddd (eg 1 459 000, d=digit)

six to:
ddd ddd (eg. 666 000)

five to:
dd ddd (eg. 55 123)

Four to:
d ddd (eg. 3000)

using find/change I am able to find all instances of for example 7 digits in a row with the grep line d{7} but i am lost at having a command for how to "change" using the found numbers and adding a thin space at the right positions.

Is there a way of writing a script or a find/change query for this operation for doing this anywhere in the text (or just the table)? Any tips on this are much appreciated!

10.01% popularity Vote Up Vote Down

: Copying a selection without adding a new layer in Krita Despite the title summarizing the issue, let me express same thing with different words. I am new to krita(I am actually quite new to

@Pope1402555

Posted in: #Krita #Selections

2 Comments

: Clean up the background for scanned document Could anyone please teach me how to clean up the background of a scanned document, using PS? Does PS have text recognition function that I can use

@Pope1402555

Posted in: #Background #Text

1 Comments

: How do I allow " to render rather than " in inkscape? I am developing a tool that will take Inkscape made SVG files. I want to make it so I enter various tagings like {{="test this"}}

@Pope1402555

Posted in: #Inkscape #Svg

2 Comments

: Photoshop: update copies of background layer when background layer changed In Photoshop, the background layer is filled up with a picture. This layer is duplicated and various filters are applied

@Pope1402555

Posted in: #AdobePhotoshop #Layers

1 Comments

Login to post a comment!

1 Comments

Sorted by latest first Latest Oldest Best

@Kimberly620

There is a bug in the matching engine (at least in my indesign) we will fix this first.

Find:

(.)Z
Replace

:
Replace All

Ok now we have a anchor at the end of story. Now for the magic:

Find:

(d)(?=(ddd)+(:|s))

Explanation match any digit followed by any number triplet of digits and : or any whitespace
Replace

~<

Number and thin space
Replace All

And now let us fix end marker back:

Find:

:d
Replace

leave empty
Replace All

Done.

PS: you can try if (d)(?=(ddd)+Z) works, it does not work on my machine.

10% popularity Vote Up Vote Down

Feed

: Using grep to finding long digit series and inserting thin spaces into them On my page i have a table with over 500 rows, in it one column where all cells contain a different numbers, such

More posts by @Pope1402555

: Copying a selection without adding a new layer in Krita Despite the title summarizing the issue, let me express same thing with different words. I am new to krita(I am actually quite new to

: Clean up the background for scanned document Could anyone please teach me how to clean up the background of a scanned document, using PS? Does PS have text recognition function that I can use

: How do I allow " to render rather than " in inkscape? I am developing a tool that will take Inkscape made SVG files. I want to make it so I enter various tagings like {{="test this"}}

: Photoshop: update copies of background layer when background layer changed In Photoshop, the background layer is filled up with a picture. This layer is duplicated and various filters are applied

Login to post a comment!

1 Comments

Back to top | Use Dark Theme