tonias81

so everything seems to work but realized that once the template processes, it return Br in the department. (see screenshot) I've tried enabling/disabling the Treat returned strings as tagged text function with no luck. I do not see anything in the code that would allow/not allow the break. Thoughts

Thanks Dan, the top code version worked but not the bottom one. I also included a script to remove all "special characters" as well. here is the code snippet: var DeptName = ToTitleCase(Field("department")); var exceptions = [ "a" , "an" , "the" , "for" , "and" , "at" , "by" , "of" , "on" , "to" , "with" ]; for (var e in exceptions) { var exception = exceptions[e]; DeptName = DeptName.replace(new RegExp("\\b" + exception + "\\b", "gi"), exception); } var specialChars = "!@#$^%*()+=-[]\/{}|:<>?,."; for (var i = 0; i < specialChars.length; i++) { DeptName = DeptName.replace(new RegExp("\\" + specialChars, "gi"), ""); } switch (DeptName) { case "Dining & Catering": case "Parent & Family Connections": case "Department of Technology Leadership & Innovation": break; default: DeptName = DeptName.replace("&", "and").replace("Dining and Catering", "Dining & Catering") .replace("Parent and Family Connections", "Parent & Family Connections") .replace("Department of Technology Leadership and Innovation", "Department of Technology Leadership & Innovation") ; break; } return DeptName Again, thanks so much Dan! -------------- Tony Hayden Xerox

Hello all, I am looking to have a department title change to TitleCase but not conjunctions (to, for, and, the, but, etc.) but I end up getting user input "office of the president" or "OFFICE OF THE PRESIDENT" to translate to "Office Of The President". If I fix one, I lose the other. I also need to have the "&" translate as "and" with an exception to the following: "Dining & Catering", Parent & Family Connections", and "Department of Technology Leadership & Innovation". I believe this code snippet works for that fix. Any thoughts about the title case conjunctions issue? var DeptName = ToTitleCase(Field("department")); DeptName = DeptName.replace("&","and").replace("Dining and Catering","Dining & Catering") .replace("Parent and Family Connections","Parent & Family Connections") .replace("Departmen of Technology Leadership and Innovation","Department of Technology Leadership & Innovation"); return DeptName Thanks, Tony Hayden Xerox