There's an option in the merge dialog to Remove Blank Lines.
Keep in mind that a line is only blank though, if it contains nothing but a field with no data. Spaces or punctuation are not "empty."
I'll give it a try. I'll let you know what I find. Thanks for your reply.
I can get the removal of blank fields to work when the addres is stacked, i.e.
but my problem is that in some artworks I have to list the addresses in a line, i.e.
Name, Add 1, Add 2, Town, etc.
If there is no Add 2 info I am getting a double space appear, which I can do a search and replace for afterwards, but if you do that, it then removes the data tag which I don't want to do, just in case the data is updated at some point in the future and Add 2 details are included.
Does anybody have any suggestions how I may get around this or cheat my way around it, perhaps using grep styling?
Styles can't remove data, only modify text formatting, and you can only modify the format for actual text so I don't think this is an option. It's probably scriptable to remove the null fields, but that would mean if the data changes you'd need tor re-run, not update, the merge. I don't find that terribly onerous, but for a really long merge you might.
There could potentially be around 1500 artworks that will have this scenario, so again I would have to ask anybody, is it possible to remove the double space whilst creating the data merge in the first place.
The only way to remove "blank data" during a merge is to have it be the only thing on the line, or to rebuild the data source itself so that you are using a concatenated field in that spot.
Aside from scriptable, once the merge happens to a new document and is checked and found good, it looks to me that one could just do a search and replace in the document to snug things up.
I think I see what you mean, If I have a column for Add1 and a column for Add2 if I then create a third column in the database and concatenate the two columns together and give it a new independent heading, I can use Add1 and Add2 in the stacked artworks and the concatenated data for copy the flows on and build a comma into the column at the same time.
I will have a play and see what I can figure out.
Thanks for the tip.