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.
