At 01:58 PM 5/4/2005, Ray Hartman wrote:
There must be a hyphen between the two when both are present. Of course this is easy, except when the 4 digit extension is blank, then the hyphen should not be present. Can I use a variable expression for this?
Ray,
Define a column such as PostalZipCode TEXT (10) with the following expression:
(IFEXISTS(ColumnWith4Digits,(ColumnWith5Digits+'-'+ColumnWih4Digits),ColumnWith5Digits))
That's all there is to it!
Hope that helps.
Very Best R:egards,
Razzak.
--- 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.
================================================
