Jump to content

A Rule associating with a comma and suffix of a name


swilson

Recommended Posts

Hi,

 

I have a data file with the fields:

Pre Name

First Name

Initial

Last Name

Post Name (Suffix)

 

When I create my text box in Fusion Pro and add in the fields, I also type a comma in there. However, not everyone has a Post Name (Suffix). I would need somehow for that comma only to be used when the person has a Post Name. Please let me know how I can accomplish this.

 

thanks,

Stephanie

Link to comment
Share on other sites

  • 1 year later...

To elaborate and revive this thread, I am having the same issue but the code Dan posted isn't working for me. I've played around with it quite a bit and think I must be missing something obvious here.

 

I have the fields:

First Name

Last Name

Title

 

In my variable text is set up as so: «First Name» «Last Name», «Title»

 

Not every name has a title, so I want to remove the comma when the Title field is empty.

 

The code I was using is:

return Field("Title") ? ", " + Field("Title") : "";

 

Help please!

 

Mariah

Link to comment
Share on other sites

This is definitely not the best, easiest or most efficient but you could us something like this:

 

//commaRule (This is the rule name)

 

if (Field("Title") != "")

return ", " + Field("Title");

else

return "";

 

Then in your text frame you wouldn't put the comma just the rule.

Field("First Name") Field("Last Name")commaRule

Link to comment
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.

×
×
  • Create New...