David,
I've done this before but only for 4 lines. Maybe you can take what I've
done and expand it to your 8 lines of data.
Example: Variable Located in Report: If vCitySt3
is null:
Brown, Roger vName Brown,
Roger
3 Main St. vStreet 3 Main St.
Apt. 3 vCitySt3 Boston, MA
02112
Boston, MA 02112 vCitySt4
Variable List:
==============
Vname text = (lastname+','&firstname)
Vstreet text = street in tablename
Vstreet2 text= street2 in tablename
Vstreet3 text= ' '
VCitySt = (city+','&state&zipcode) in tablename
vCitySt3 text= (ifnull(vstreet2,vcityst,vstreet2))
vCitySt4 text= (IFNULL(VSTREET2,VSTREET3,VCITYST))
Hope this helps.
Bill Eyring
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
