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. 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)}); 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! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.