Jump to content
Sign in to follow this  
Evan Luke

Handling Blank Fields in Merge Field Bulleted List

Recommended Posts

I have 5 different "fact" fields that I am outputting in a merge field.

The challenge I have is when one of the fact fields is blank, I get a orphaned bullet point with no content.

Is there a way to build conditionality into the merge field so that bullets are omitted if the following field is blank?

Share this post


Link to post
Share on other sites

Make a calc field with the formula:

Case ( Trim ( FieldA ) = "" ; "" ; "• " & FieldA ) 

& "¶" & 

Case ( Trim ( FieldB ) = "" ; "" ; "• " & FieldB ) 

& "¶" & 

Case ( Trim ( FieldC ) = "" ; "" ; "• " & FieldC )

& "¶" & 

Case ( Trim ( FieldD ) = "" ; "" ; "• " & FieldD )

& "¶" & 

Case ( Trim ( FieldE ) = "" ; "" ; "• " & FieldE )

The result will be a list without 'empty bullets', but with 'empty returns'. You can strip these out with the custom function RemoveEmptyValues

If you don't want to use a custom function you might try to use the Substitute function to get rid of the superfluous returns.

Success,

Henk

Share this post


Link to post
Share on other sites

Or you can use:

"• " & Substitute ( List ( fieldA ; fieldB ; fieldC ; fieldD ; fieldE ) ; ¶ ; "¶• " )

... which eliminates the blank lines if any of the fields are blank. It's just another approach. You might also consider placing it inside a web viewer which would eliminate the calculation field alltogether.

Oh Henk! You modified your post! Ah well, I've leave mine anyway. :wink2:

Oh! And Evan? Welcome to FM Forums!! :laugh2:

Edited by Guest
Added second Oh!

Share this post


Link to post
Share on other sites

Oh Henk! You modified your post! Ah well, I've leave mine anyway.

????????

BTW LaRetta: Nice formula (using the list function) ...

Edited by Guest
Added credit to LaRetta

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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