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

Export of certain textparts

New Here ,
Sep 15, 2020 Sep 15, 2020

Copy link to clipboard

Copied

Hi

I have a 300+ page catalogue and I need to extract only the article numbers (from text fields and tables), so they can be compared in Excel.

How do I approach this? I’am aware that I need to tag or give every number a type format(?) but how do I proceed?

Or is there a script for a task like that?

 

Thanks for your help

TOPICS
How to , Import and export

Views

196

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 , Sep 15, 2020 Sep 15, 2020

One way would be to ensure that they all have a Paragraph style that is unique.

 

Then you can create a Table of Contents and only those headings would be in it.

https://helpx.adobe.com/ie/indesign/using/creating-table-contents.html

 

Or you could do something similar using Cross References to build a table of contents

 

Votes

Translate

Translate
Community Expert ,
Sep 15, 2020 Sep 15, 2020

Copy link to clipboard

Copied

One way would be to ensure that they all have a Paragraph style that is unique.

 

Then you can create a Table of Contents and only those headings would be in it.

https://helpx.adobe.com/ie/indesign/using/creating-table-contents.html

 

Or you could do something similar using Cross References to build a table of contents

 

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 ,
Sep 15, 2020 Sep 15, 2020

Copy link to clipboard

Copied

LATEST

I've written a script for a client that simply does this:

 

The client opens the InDesign Find/Replace window, types in the "find" form the Grep code to find all these numbers, as, for example, "\b\d{8}\b" (that finds all numbers with 8 digits), tests the F/R once and runs the script!

Then, he goes to Excel, creates a new doc and "paste"!

The Excel doc first cell is automatically selected and the list of the numbers found in the InDesign doc that had been previously copied by the script in the clipboard is now pasted in it (one found per cell).

Of course, the list is sorted and the duplicated instances removed!

 

Simple and cool!

 

(^/)  The Jedi

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