News:

Main Menu

VDP Brainfart

Started by Slappy, May 09, 2018, 08:58:53 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

Slappy

May 09, 2018, 08:58:53 PM
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.

scottrsimons

#1
May 10, 2018, 06:04:06 AM
Quote from: Slappy on May 09, 2018, 08:58:53 PMI'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.
"Your superior intellect is no match for our puny weapons!" - Homer J. Simpson

DigiCorn

#2
May 10, 2018, 09:08:12 AM
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.
"There's been a lot of research recently on how hard it is to dislodge an impression once it's been implanted in someone's mind. (This is why political attack ads don't have to be true to be effective. The other side can point out their inaccuracies, but the voter's mind privileges the memory of the original accusation, which was juicier than any counterargument ever could be.)"
― Johnny Carson

"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

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

AaronH

#3
May 10, 2018, 03:49:02 PM
Quote from: Slappy on May 09, 2018, 08:58:53 PMI'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.
Mac & Windows | XMF | Fiery | Oris

Slappy

#4
May 10, 2018, 08:37:27 PM
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.
Print
Go Up Pages1
User actions