AnsweredAssumed Answered

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

Question asked by mcrostie on Feb 2, 2015
Latest reply on Oct 2, 2015 by thurmes

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

Outcomes