8 Replies Latest reply on Oct 30, 2010 9:15 AM by ChangeAgent

    How to filter out countries in a adress label.

    ChangeAgent

      Title

      How to filter out countries in a adress label.

      Post

      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 (

      List (

      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.

      Mrs M

      M Cottage

      M Street

      M Town

      End. 

      Should she live in France the country should print.

      Mrs M

      M Cottage

      M Street

      M Town

      France

      I suppose this should happen in the line: > TrimAll ( Upper ( Country 1 ) ; 0 ; 0 ) ; < but I do not know how to do this.  Anybody?