AnsweredAssumed Answered

How to filter out countries in a adress label.

Question asked by ChangeAgent on Oct 29, 2010
Latest reply on Oct 30, 2010 by 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?

Outcomes