Mr./Mrs.

[mkruter]

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

[Inky Phil]

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

[mkruter]

PERFECT!!!

[mkruter]

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?

[mr_vodka]

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

          )

    )

           

[mkruter]

Great, everything works perfectly now, thank you!