Remove empty lines from address

[scottian]

I have a text file that i recieve regularly containing customer data which in certain cases i need to send a letter to. The address data in the file is split between -housename-, -housenumber-, -street-, -area-, -county- etc.

In some cases the house name field will be empty, or the house number will be empty, or the street might be empty etc. Is there a way to display the address on a report so these empty fields are not displayed?

"My God! It's full of stars...

 

[Remou]

This may help:
BLANK LINES IN NAME ADDRESS FIELD
thread703-768586

 

[scottian]

Brilliant, didnt know about the "Shrink-Grow" setting.

Thanks

"My God! It's full of stars...