p01 Kansas City Southern
Skip to main content

Recent Topics

xx

xx

angry
Trouble with InD VDP
by delooch
May 21, 2018, 06:01:35 PM

xx
Adobe Creative Cloud Price Increases
by Joe
May 17, 2018, 05:48:25 PM

xx
PKG Installer Inspection
by Slappy
May 17, 2018, 01:36:00 PM

xx
Business Card order
by scottrsimons
May 16, 2018, 10:27:26 AM

xx
Ink saving,4d colour conversion
by danydany
May 16, 2018, 10:10:07 AM

xx

clip
java and 3D Export
by Joe
May 15, 2018, 08:42:11 PM

xx
Individual Page Proofs
by Slappy
May 14, 2018, 11:12:05 PM

xx
Prinergy 1st Refines Questions
by DPSprint
May 14, 2018, 10:48:01 PM

xx
Xeikon Indigo toner press Iso standards
by danydany
May 14, 2018, 10:21:55 AM

xx
Still alive!
by motormount
May 12, 2018, 12:49:13 PM

xx
VDP Brainfart
by Slappy
May 10, 2018, 10:37:27 PM

Topic: VDP Brainfart (Read 211 times) previous topic - next topic

VDP Brainfart

I'm guessing this might obvious as the nose on my face, but after a lonnnnng 3 days, I was stumped.

Simple data job, <<City>>, <<ST>> but the entries without a City, ST still have a comma once merged. Typing this out now, I guess I should just concatenate the two fields in Excel, add the comma/space there & make it one entry in Data Merge huh?
A little diddie ‘bout black 'n cyan...two reflective colors doin’ the best they can.

Re: VDP Brainfart

Reply #1
I'm guessing this might obvious as the nose on my face, but after a lonnnnng 3 days, I was stumped.

Been there.

All depends on how much work you have done on the VDP side of it, and what software your are using to do the merge. Plus if you can figure an easy solution to it now, you will have it for future situations. And should be able to always use it, so it will not be an issue "ever" again. Yeah right, but there is hope.
Mac • Prinergy 8 • Preps 8 • RBA • Fusion Pro

"Your superior intellect is no match for our puny weapons!" - Homer J. Simpson

"Those who make you mad, control you."

Re: VDP Brainfart

Reply #2
If you are doing an ID mail merge, that is probably the quickest way to resolve. If you are using FusionPro, you can write a quick script to remove the comma.
"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: VDP Brainfart

Reply #3
I'm guessing this might obvious as the nose on my face, but after a lonnnnng 3 days, I was stumped.

Simple data job, <<City>>, <<ST>> but the entries without a City, ST still have a comma once merged. Typing this out now, I guess I should just concatenate the two fields in Excel, add the comma/space there & make it one entry in Data Merge huh?

If you're doing the data merge in InDesign, that's what I would do. Concatenate has been a huge friend of mine since I think Tracy pointed it out.

 

Re: VDP Brainfart

Reply #4
I actually logged back in remotely, sent the files to our Mail Guy & begged him to do 'em for me for the morning! Helluva guy, busy as he is all the time, it was on my machine when I showed up bright & early and he didn't even make me feel too much like a dweeb.
A little diddie ‘bout black 'n cyan...two reflective colors doin’ the best they can.