Highlighted

Export of certain textparts

New Here ,
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

Adobe Community Professional
Correct answer by Eugene_Tyson | Adobe Community Professional

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

 

Topics

How to, Import and export

Views

40

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

Export of certain textparts

New Here ,
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

Adobe Community Professional
Correct answer by Eugene_Tyson | Adobe Community Professional

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

 

Topics

How to, Import and export

Views

41

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 ,
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

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...
Advocate ,
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

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...