I would like to have my "Name Title Male" field and my "Name Title Female" field together with "/" in between. That part is easy using the "&" symbol to concatenate within a calculation and placing "/" between them. But when there is no spouse and one of the fileds is blank it displays "Mr./" which is obviously no good. I created a new field just for the "/" symbol and tried a variety of calculations including "If(IsValid(Name Title Male and Name Title Female);"/";"")". My assumption was that only when both fields are populated will it show "/" otherwise it will show nothing.

What am I doing wrong?

-Marc

How about making the '/' field an unstored calc field along the folowing lines

Case(Is empty(Name Title male) or Is empty(Name Title Female);"";"/")

If I understand what you want that will make the '/' appear only of both of the title fields have something in them

HTH

Phil

PERFECT!!!

Phil, thank you so much!

Perhaps you can help me out with the rest of my problem as well.

I applied the calculation you provided to a "Titles" calculation that gets the left most value so that my titles field now correctly displays "M/M" or just "M" (without the /) and also to the first names field so that "Marc & Ruth" would be "Marc" and not "Marc &". However, in the case of only one title I not only wanted to get rid of the "/" but also have my "Left" function not operate.

Currently "M/M Marc & Ruth" would become "M Marc" but I would like it to instead display "Mr. Marc".

My current Titles calculation is "Left ( Name Title Male ; 1 ) & Titles Seperator & Left (Name Title Female ; 1)", the "Titles seperator" field is of course the calculation that you provided above. Is it possible to do what I want?

Off the top of my head, try something like this. I havent fully checked syntax.

Let ( [ ef = Case (Is empty(Name male) or Is empty(Name Female);1; 0); 

        tm = Left ( Name Title Male ; 1 );

        tf = Left ( Name Title Female ; 1 ) 

      ];

     

     Case ( 

            ef = 1; Name Title Male & Name Title Female & " " & Name Male & Name Female;

            tm & "/" & tf & " " & Name Male " & " & Name Female

          )

    )

           

Great, everything works perfectly now, thank you!