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



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




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?




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

  • 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



    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