City State Zip comma 1

[schwarem]

I am using putting City, State, and Zip together into one field. I want to not include the Comma if City state and zip are not specified. Right now, if they are not specified, the comma still appears.

 

[AndyMc]

schwarem,

Try:

stringvar stateZip := trim({statefield} & " " & {zipField});
stringvar city := trim({cityfield});

If city = "" then
stateZip
else if stateZip = "" then
city
else
city & ", " & stateZip

Andy

 

[lbass]

Try:

{table.city}+
(
if isnull({table.city} and
isnull({table.state}) and
isnull({table.zip}) then
"" else
", "
) + {table.state}+" "+{table.zip}

This requires all three fields to be null in order to eliminate the comma. You might want to adjust and eliminate the null zip requirement.

-LB