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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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