City State Zip as an Expression

Example:         

Use in Data Pipeline with the Calcs icon (calculator) to make an Expression:

rtrim(rtrim(indv.city)+', '+indv.st)+' '+rtrim(indv.zipcode)

NOTE: If you wish to include country, use this formula:

Example:      

rtrim(rtrim(indv.city)+', '+indv.st)+' '+rtrim(indv.zipcode)+iif(length(rtrim(indv.country)) >0,', '+indv.country,' ')