g.bevan Posted April 5, 2001 Posted April 5, 2001 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.
Vaughan Posted April 5, 2001 Posted April 5, 2001 Use a conditional If[] statement in conjunction with IsEmpty[] function... If[isEmpty[field], <empty>, <not empty>]
LiveOak Posted April 5, 2001 Posted April 5, 2001 Maybe I'm missing something, but the concatenation of blank fields is still a blank field. 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
g.bevan Posted April 5, 2001 Author Posted April 5, 2001 Ok Vaughan, just to make sure I've got this. Using only three fields to keep this uncomplicated , are you saying I should do the following? (deep breath): If[isEmpty[field1], field2 & "
Vaughan Posted April 6, 2001 Posted April 6, 2001 Nearly... Let's think the logic out a bit: let's say you want to join the fields together with
g.bevan Posted April 6, 2001 Author Posted April 6, 2001 Ahhh...yes, that looks better - I seem to have a panache for over complication I'm afraid 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
g.bevan Posted April 9, 2001 Author Posted April 9, 2001 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 & "
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now