Skip navigation
Currently Being Moderated

Apply Find/Change to multiple records at once?

Dec 13, 2012 2:25 PM

Tags: #scripts #data_merge #multiple_records #find_change

Hi,

 

I'm wondering if there is a way to apply the find/change options I select to all the records I've Data Merged into my InDesign file.

 

The placeholders won't import the spaces in my database, example if I have

 

 

InDesign template:     <<bird>>

                                        <<beak>><<beak value>>

.csv:                              bird,beak,beak value

                                     Eagle,beak:        ,hooked

 

I get

 

InDesign after Data Merge:  Eagle

                                                 beak:hooked

 

 

No spaces came over with the merge.  If there is an option to preserve spaces, that would be the easiest solution. However, I'm not finding such a command, so I'd like to add a special character after my colons in the .csv and then use ID to find/change that character in every one of my records into a space or two.  Any ideas?

 

Thanks.

 

edit: Even on a single record, the find/change isn't applying to my output document, either... Its outputting the special character I wrote into the  .csv fields instead of the space it is supposed to change into.

 

Message was edited by: EX_Achilles

 
Replies
  • Currently Being Moderated
    Dec 13, 2012 2:33 PM   in reply to EX_Achilles

    You don't need a special character in the CSV. Just search for (?<=:). and replace with <space>$0 in the merged file.

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 13, 2012 6:20 PM   in reply to EX_Achilles

    Yes.

     

    Make sure you set the scope for the find/change to Document. It may have defaulted to Selection or Story.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points