How to filter out countries in a adress label.
I have a DB where I pull together several fields in order to create a address label. I do this in a calculation field, with the following script.
TrimAll ( Title & " " & First Name & " " & Last Name ; 0 ; 0 ) ;
TrimAll ( Company ; 0 ; 0 ) ;
TrimAll ( Street 1 ; 0 ; 0 ) ;
TrimAll ( Postal Code 1 & " " & City 1 ; 0 ; 0 ) ;
TrimAll ( State Province 1 ; 0 ; 0 ) ;
TrimAll ( Upper ( Country 1 ) ; 0 ; 0 ) ;
0 ; 0 )
I would like to filter out the name of a country (not print it) if I am in that country.
For example if I am in the UK and generate a label, I do not want the UK showing.
Should she live in France the country should print.
I suppose this should happen in the line: > TrimAll ( Upper ( Country 1 ) ; 0 ; 0 ) ; < but I do not know how to do this. Anybody?