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

84

Likes

translate

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

Adobe Community Professional , 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  

Likes

translate

Translate

Translate
Adobe Community Professional ,
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

 

Likes

translate

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

Copy link to clipboard

Copied

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

Likes

translate

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