Concatenate where a cell is empty or null

Hi there,

I'm trying to concatenate some address fields but the columns I am using are the content is not uniform and is spread across 3 columns.

In the example above, I know how to concatenate buildingNumber with the DoubleThoroughfare&descriptor field. But where DoubleThoroughfare&descriptor field is empty I want to concatenate buildingNumber with the Thoroughfare&descriptor.

Is there a way of dong

Tips and Tricks

Fuzzy Match

Preparation

Data Investigation

Accepted answers

atcodedog05

Hi @JamesDB

Use ISNULL in a IF statement and you will be able to get it.

Sample formula

if isempty(DoubleThoroughfare&descriptor) then

concatenate buildingNumber with the Thoroughfare&descriptor

Else concatenate buildingNumber with the DoubleThoroughfare&descriptor endif

I can build you a sample workflow 🙂

All comments

atcodedog05

Hi @JamesDB

Use ISNULL in a IF statement and you will be able to get it.

Sample formula

if isempty(DoubleThoroughfare&descriptor) then

concatenate buildingNumber with the Thoroughfare&descriptor

Else concatenate buildingNumber with the DoubleThoroughfare&descriptor endif

I can build you a sample workflow 🙂

Emil_Kos

Hi @JamesDB,

If your data is stirng you can just sum them together using formula tool.

Concat.yxmd

atcodedog05

Hi @JamesDB ,

Here is the exact formula

IF IsEmpty([DoubleThoroughfare&descriptor]) 
THEN ToString([buildingNumber])+"-"+ [Thoroughfare&descriptor]
ELSE ToString([buildingNumber])+"-"+ [DoubleThoroughfare&descriptor]
ENDIF

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Concat.yxmd

JamesDB

That's saved a lot of time and effort.

Thank-you.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335