Skip to main content
F
fast_and_the_curious
Participating Frequently
January 6, 2022
Question

Finding and highlighting from Excel

  • January 6, 2022
  • 6 replies
  • 1081 views

So here is my dilemma and a BIG ASK!
I have a lot of documents (100s) that need company names removed from them that are in the text. Is there a script (plugin/something) that will search an Indesign document using the keywords (company names) from (for example an excel file) and highlight the text in the Indesign document where those words appear?

 

Open to other suggestions as well.

 

Thanks in advance.

This topic has been closed for replies.

6 replies

L
Laubender
Braniac
January 7, 2022

And here another suggestion:
If you have a functional script* you can run it with Peter Kahrel's Batch Process script on open InDesign documents, on all InDesign documents of a specific folder or on all InDesign documents in a nested folder structure:

 

https://creativepro.com/files/kahrel/indesign/batch_convert.html

 

*scroll down to section:

Run a script

and read into the notes at "Important".

 

Regards,
Uwe Laubender

( ACP )

    F
    fast_and_the_curiousAuthor
    Participating Frequently
    January 14, 2022

    Thank you all. I'm still working on a solution.

    J
    jctremblay
    Braniac
    January 7, 2022

    You could also us Multi Find/Change extension to load a CSV directly. This is a paid extension but it worth all the 60$. Many others useful features.

    https://www.automatication.com/product/mfc/

      Brad @ Roaring Mouse
      Brad @ Roaring Mouse
      Inspiring
      January 7, 2022

      Remember that you will also need to have some way of scanning for the text in placed graphics. e.g. if you have an organizational chart created in llustrator, you can't search for that in InDesign.

      F
      fast_and_the_curiousAuthor
      Participating Frequently
      January 7, 2022

      Good point @Brad @ Roaring Mouse 

      Willi Adelberger
      Willi Adelberger
      Inspiring
      January 7, 2022

      Find and replace is the function. Find and replace with a character style.

      There is a script delivered with and you can adapt it for your purpose.

      brian_p_dts
      brian_p_dts
      Braniac
      January 6, 2022

      You can look at modifying the preinstalled FindChangeByList script. A breakdown of it is here: 

       

      https://yourscriptdoctor.com/findchangebylist/

        F
        fast_and_the_curiousAuthor
        Participating Frequently
        January 6, 2022

        That's an interesting one! I'll look at that and get my head around it. Thanks.

        J
        jctremblay
        Braniac
        January 6, 2022

        You want to highlight them or delete them.
        How many compagny name you have?

        F
        fast_and_the_curiousAuthor
        Participating Frequently
        January 6, 2022

        Hi Jean-Claude

        I would say highlight them initially with a view to deleting. There are approx 200+ company names.

        If I could search and highlight all in one go per document that is the aim

        J
        jctremblay
        Braniac
        January 6, 2022

        You could build a long query (with your 200 name), with underline custom format in change to, than save it.
        Next you can use Peter Kahrel Script Grep Query Manager to run that query to a folder full of files.

        GrepQueryManager > https://creativepro.com/files/kahrel/indesign/grep_query_manager.html

        You can create you query that way, each comany name separaated by a pipe |

        (?i)\b(cie1|cie2|cie3)\b

         

        Terms & ConditionsAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices