Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8614 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hi,

I'm trying to create a calculation field to concatenate multiple fields (about 10)into a single field (field1 & field2 etc). Thing is, some of the fields are empty and I do not want to add those fields. Does anyone know of a way to do this?

Thanks,

Grahame.

Posted

Use a conditional If[] statement in conjunction with IsEmpty[] function...

If[isEmpty[field], <empty>, <not empty>]

Posted

Maybe I'm missing something, but the concatenation of blank fields is still a blank field. wink.gif" border="0 You don't need the test. IsEmpty will not detect a field full of spaces as "empty". The calculation can be:

Field1 & Field2 & Field 3 & Field4

The only time you need the IsEmpty is if you are concatenating the fields with a delimiter such as <cr> or dash.

-bd

Posted

Ok Vaughan, just to make sure I've got this. Using only three fields to keep this uncomplicated wink.gif" border="0, are you saying I should do the following? (deep breath):

If[isEmpty[field1], field2 & "

Posted

Nearly... Let's think the logic out a bit: let's say you want to join the fields together with

Posted

Ahhh...yes, that looks better - I seem to have a panache for over complication I'm afraid smile.gif" border="0

Thanks very much for your help.

Regards - Grahame.

quote:

Originally posted by Vaughan:

Nearly... Let's think the logic out a bit: let's say you want to join the fields together with
Posted

Hi Vaughan,

Hope you don't mind me asking another question related to this last one. The formula you helped me with is working great for my flat-file databases. I'm now trying to achieve something similar with a relational database. The formula I'm using is:

If( IsEmpty(Tel_Dir_cont::Name), "", Tel_Dir_cont::Name & "

This topic is 8614 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.