strido Posted January 30, 2012 Share Posted January 30, 2012 return ToTitleCase(Field(Var1)); That's the proper case rule, but if I have a name followed by Acronyms, such as "Strido, EEK, AAC, DOH" - what's the syntax that would allow me to put "Strido" in proper case, but ignore the rule for everything after the comma? These Acronyms will be in the same field as the last name, preventing me from using the proper case correctly. They'd come out as Eek, Aac, Doh. Quote Link to comment Share on other sites More sharing options...
Alex Marshall Posted January 30, 2012 Share Posted January 30, 2012 Hello I believe this should work. return Field(Var1).replace(/([^,])*/, function(w){return ToTitleCase(w)}); Quote Link to comment Share on other sites More sharing options...
strido Posted January 30, 2012 Author Share Posted January 30, 2012 ...wish that wasn't all jibberish! Thanks - worked like a charm! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.