Concatenate, but skip over blank value

(0) Share

Report

Posted on by jessicadduffey

Hello -

I'm looking to concatenate the values from a selected record from 5 columns:

Address

Address2

City

State

Zip

So that when the formula is executed, I have something like this: Address, Address2, City, State Zip

Here is the formula that I've written

Concatenate(varSelectedLoc.Address,", ",varSelectedLoc.Address2,", ",varSelectedLoc.City,", ",varSelectedLoc.State," ",varSelectedLoc.Zip)

Address2 often has a blank value in my table, but not in every situation. Is there any way that this formula can be amended to skip over the blank value so that I still come up with something like this: Address, City, State Zip?

All responses (1)

Answers (1)

Verified answer

LaurensM 12,510 Super User 2025 Season 1 on at

Like (2)

Report
Re: Concatenate, but skip over blank value

Hi @jessicadduffey,

If only Address2 may sometimes be empty, you could use the following approach:

$"{varSelectedLoc.Address}, {If(!IsBlank(varSelectedLoc.Address2), varSelectedLoc.Address2 & ", ")}{varSelectedLoc.City}, {varSelectedLoc.State}, {varSelectedLoc.Zip}"

In this case we use string interpolation to improve readability and use an If statement to only display Address2 when it has a value. (I have also added a comma between State and Zip.)

If we expect multiple fields to possibly be empty, we may need a more dynamic approach.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!