This content has been marked as final. Show 5 replies
Let ( L = Left(PostalCodeField ; 1 ) ;
If ( isempty( getasnumber ( L ) ) ; L ; Left (postalcodefield ; 3 ) ) )
Let ( [
char = Left ( Zip ; 1 )
Case ( char ; Left ( Zip ; 3 ) ; char )
Sorry for the confusion, but I don't understand the capital L used in your formula. The Canadian codes can be anything from A-Z, less a couple options. Does this matter?
L is a temporary variable defined by the Let function and assigned the value of the first character in the zip code field. In comment's version, he named this variable "char".
Thank you both so much. As you knew, both recommendations worked seamlessly. I've been using FMP since 2.0. I'm not formally trained programmer, and I can tell in situations like this that more formal training would be helpful. Thanks again!