>>>Tore .. you beat me to it!! I use this trick all the time and I have found that very few people know about it. Usually when I show this trick in a session at a conference somone will ask if this is new to version [the latest]. When I tell them this has been around since Dos -- everyone is in shock!!
>>>
>>>Cathy
>>>
>>>
>>>>Did you know that you can simplify this with an old trick which is not commonly known, but which has been around since DOS days? Enter ONE line like this:
>>>>m.company
>>>>M.addr1;M.addr2;M.addr3;m.addr4;city,state,' '+zip
>>>>I'm sure you won't believe me, but this one line will do ALL the things you want! The semicolon means 'print the next word on a new line if it's not empty', the komma means 'trim the next words and separate them on one line with a space between them.
>>
>>Yes, very nice and right what I need.
>
>And you only needed 14 months to find it? :-)
Nope, I knew this trick, but right now I'm working on a report where this would be right on the money, so I decided to re-check it and found my own message leading to this one.
But I did get the joke, don't worry <g>
If it's not broken, fix it until it is.
My Blog