1 Reply Latest reply on Oct 2, 2015 10:08 PM by thurmes

    TrimAll (  Proper( Substitute"MC"; "Mc "); "Mc"; "Mc "); "O'"; "O' ")

    mcrostie

      Hi All

       

      My head is not working for the following

       

      TrimAll ( 

      Proper(

      Substitute(

      Substitute(

      Substitute(

      ImportSurname;

      "MC"; "Mc ");

      "Mc"; "Mc ");

      "O'"; "O' ")

      );

      0 ;3 )

       

      I am getting a capital after the Mc (i.e. mcrostie to McRostie)  formatting but not after the O' (i.e. O'Gorman to O'gorman)

       

      Could it be the Trim All Function?

       

      Thanks

       

      Michael