p01 Kansas City Southern
Skip to main content

Recent Topics

xx

xx
Only took 30 years
by Slappy
Today at 07:13:44 PM

xx
Metal Plate Hanging Tab Thingies
by Joe
Today at 06:06:07 PM

clip

xx
Preflight for black text
by Tracy
Today at 01:26:05 PM

xx
Xmpie or Fusion Pro
by pspdfppdfxhd
October 15, 2018, 02:09:06 PM

clip
How to make type into single stroke for engraving
by Tracy
October 15, 2018, 10:02:28 AM

xx
Acrobat excessive RAM usage
by Joe
October 12, 2018, 06:20:51 PM

xx

xx
Mac Email Client
by Joe
October 11, 2018, 02:01:39 PM

clip
Text moves when box is duped
by DCurry
October 10, 2018, 01:30:33 PM

xx
Font Management
by Joe
October 09, 2018, 05:30:47 PM

xx
Mojave (and Acrobat DC)
by Joe
October 09, 2018, 04:51:24 PM

xx
Export PDF reverse pages?
by wonderings
October 09, 2018, 01:08:09 PM

Topic: InDesign mail merge question (Read 490 times) previous topic - next topic

InDesign mail merge question

Without the use of a third party plug-in or software, does anyone know how to remove a space inserted between two fields on the same line in the even that one of the fields is empty? I know if you click "remove blank..." it removes the entire line, but I just need to remove the space character between two fields...

OR

I need to merge the two fields together either in InDesign OR merge the two columns in Excel (also removing the space).
"I'm not addicted to cocaine. I just like the way it smells."
– Richard Pryor

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway

Re: InDesign mail merge question

Reply #1
what happens when you merged the two fields in excel?

Re: InDesign mail merge question

Reply #2
We figured that part out... now just looking for an indesign repair
"I'm not addicted to cocaine. I just like the way it smells."
– Richard Pryor

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway

Re: InDesign mail merge question

Reply #3
Maybe add/remove the double space in the merge data before importing it into indy?
Speed doesn't kill, rapidly becoming stationary is the problem

I'd rather have stories told than be telling stories of what I could have done.

It's more like grip, grip, grip, noise, then spin and 2 feet in and feel shame.
I once knew a plus-sized girl and this pretty much describes teh secks. :rotf:
They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety.
         —Benjamin Franklin

My other job

Re: InDesign mail merge question

Reply #4
no...
imaging you have these fields:  <<address1>> <<address2>> with the space in between, and on the same line...
maybe in some cases, <<address1>> has nothing in it (but mostly <<address2>> is empty... mostly....) and you want to have ID remove the space in the instances where <<address1>> is blank so that <<address2>> scoots over and is still aligned with the lines above and below.
"I'm not addicted to cocaine. I just like the way it smells."
– Richard Pryor

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway

Re: InDesign mail merge question

Reply #5
can you add a space after address 1 instead of adding the space in indesign, there is a way to honor the space
also you could merge Address 1 with a column that has an unused character and find change in indy to a space

Re: InDesign mail merge question

Reply #6
Is there a quick way to do this in the event there are thousands of records?
"I'm not addicted to cocaine. I just like the way it smells."
– Richard Pryor

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway

Re: InDesign mail merge question

Reply #7
So the space is not in the fields? It just a space between the 2 fields in InDesign. Backspace key to delete the space? You can tell InDesign to ignore empty fields and when address1 is blank address2 should move over into its place.
Mac OS 10.12 Sierra | Prinergy 7.5 | Adobe Creative Cloud 2017 | Two Luscher XPose 160 CTP units

Prepress: One who does precision guess work based on unreliable data provided by those of questionable knowledge.

Re: InDesign mail merge question

Reply #8
create a new column type   =concatenate(A1," ",B1)
the a1 and b1 is your column letters so adjust accordingly
the quotes have a space in between for adding a space

and then copy the formula (new fieldname) all the way down, click new  field cell and you will see a plus sign bottom right of the cell, drag all the way down. let me know if you need a screen shot

start typing =c and concatenate will show up, or you can copy paste my formula and change the A and B to your column letters needed

Oh yeah almost forgot, If you try and delete your original rows weird things happen so either leave them
or create a new row select your new combined row, copy and then Paste Values into a new row, then you can delete the other rows.

Re: InDesign mail merge question

Reply #9
When there isn't an Address 1 when your doing a merge the space before address 2 will not be honored.

Re: InDesign mail merge question

Reply #10
Thanks... I'll try that out

[edit] Hey - that works in Apple Numbers too!
"I'm not addicted to cocaine. I just like the way it smells."
– Richard Pryor

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway

Re: InDesign mail merge question

Reply #11
You add the space in InDesign after you add the field in. Or at least I do it that way.
Mac OS 10.12 Sierra | Prinergy 7.5 | Adobe Creative Cloud 2017 | Two Luscher XPose 160 CTP units

Prepress: One who does precision guess work based on unreliable data provided by those of questionable knowledge.