• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

search/replace digits

New Here ,
Aug 22, 2020 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!

TOPICS
How to , Scripting

Views

218

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
community guidelines

correct answers 1 Correct answer

Community Expert , Aug 22, 2020 Aug 22, 2020

This should work

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

Votes

Translate

Translate
Community Expert ,
Aug 22, 2020 Aug 22, 2020

Copy link to clipboard

Copied

This should work

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

Votes

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
community guidelines
New Here ,
Aug 22, 2020 Aug 22, 2020

Copy link to clipboard

Copied

Thanks a lot. It works like a charm.

Votes

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
community guidelines
Guide ,
Aug 22, 2020 Aug 22, 2020

Copy link to clipboard

Copied

For any number you could try this grep

find

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

 

replace with

$0.

 

Votes

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
community guidelines
New Here ,
Aug 22, 2020 Aug 22, 2020

Copy link to clipboard

Copied

LATEST

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.

Votes

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
community guidelines