Highlighted

search/replace digits

New Here ,
Aug 22, 2020

Copy link to clipboard

Copied

How can I put a . between 6 digits. For example 000000 has to become 000.000

It are all different numbers for articles in a catalogue and the client forgot to put a . between the articlenumber in the input document in excel. I know it can be done, i did it before, but i forgot the formule  on how to do this in indesign.

Please can somebody help me so that i do not have to put a . between the numbers by hand!

Adobe Community Professional
Correct answer by jmlevy | Adobe Community Professional

This should work

Capture d’écran 2020-08-22 à 13.53.49.jpg

Topics

How to, Scripting

Views

70

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

search/replace digits

New Here ,
Aug 22, 2020

Copy link to clipboard

Copied

How can I put a . between 6 digits. For example 000000 has to become 000.000

It are all different numbers for articles in a catalogue and the client forgot to put a . between the articlenumber in the input document in excel. I know it can be done, i did it before, but i forgot the formule  on how to do this in indesign.

Please can somebody help me so that i do not have to put a . between the numbers by hand!

Adobe Community Professional
Correct answer by jmlevy | Adobe Community Professional

This should work

Capture d’écran 2020-08-22 à 13.53.49.jpg

Topics

How to, Scripting

Views

71

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Adobe Community Professional ,
Aug 22, 2020

Copy link to clipboard

Copied

This should work

Capture d’écran 2020-08-22 à 13.53.49.jpg

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
Aug 22, 2020

Copy link to clipboard

Copied

Thanks a lot. It works like a charm.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Adobe Community Professional ,
Aug 22, 2020

Copy link to clipboard

Copied

For any number you could try this grep

find

\d(?=(\d{3})+\b)

 

replace with

$0.

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
Aug 22, 2020

Copy link to clipboard

Copied

It is not for any number. After three numbers there has to be a . and then followed by three numbers.

For example 038655 has to become 038.655

The article numbers are always 6 digits total. I have 52 pages full of articles and every article has it’s own article number.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...