1 Reply Latest reply on Nov 29, 2012 7:05 PM by philmodjunk

    How to remove a middle initial

    illbe

      Title

      How to remove a middle initial

      Post

           I have a field with the format: [lastName, firstName MI] all rolled into one (thanks to a weird system, not mine). I would like to know how to remove the middle initial from the string using a calculation. Any help would vbe greatlt appreciated before my poor head explodes :-)

            

           Thank You

            

           Tom

        • 1. Re: How to remove a middle initial
          philmodjunk

               The challenge to this is that not all names will follow the same pattern, the middle initial may not be present and some people may have hyphenated names.

               Let ( wc = Wordcount (NameField ) ;
                       Case ( wc < 3 ; NameField;
                                  Length ( Rightwords ( NameFIeld ; 1 ) ) = 1 ; LeftWords ( NameField ; wc - 1 ) ;
                                  NameField )
                     )