Controls

Re: Convert user entry to Title Case

rcant — Fri, 19 Oct 2012 15:20:43 GMT

thank you hilary

eneded up using jscript solution

Re: Convert user entry to Title Case

Hilary Stoupa — Tue, 16 Oct 2012 22:20:45 GMT

In case no one has a formulaic method for you - qRules has a command called "SetCase" that can do this, in case you are interested in 3rd party solution. I added that with a bunch of other string and math commands last release.

Re: Convert user entry to Title Case

rcant — Tue, 16 Oct 2012 19:33:59 GMT

ANy able to figure out a solution to this?

I have been battling using the concat(translate(substring......

and substring-before etc....

but cannot get it to convert every word entered into the text box to be title case -- just the first and/or second word

thanks

Re: Convert user entry to Title Case

fhall — Thu, 14 Jun 2012 18:30:56 GMT

I didn't find this solution (yet), but this was helpful:
capitaize the first 2 words in a field.
http://www.infopathdev.com/forums/p/18952/79502.aspx

cheers,

Re: Convert user entry to Title Case

ErnestoM — Tue, 20 Jul 2010 12:17:40 GMT

I can imagine the following:

1. Break up the title into pieces that are separated by spaces.

2. Capitalize the first letter of each "piece" using the translate() function.

3. Use concat() to put the title back together.

I'm not sure if it'll work, but it's an idea. Good luck!

Convert user entry to Title Case

geolex1 — Mon, 19 Jul 2010 19:03:43 GMT

I've read through all the posts I can find but none of them seem to address my exact issue. Users enter a conference title into a field for submission to our database. Many times they either enter in all lowercase letters, or some random use of capitals that no one can explain. I'm looking for a way to convert their entry into title case. I've tried manipulating the concat(translate(substring examples I have found here with no success. The most I've been able to accomplish is getting the first word to capitalize but none of the others.

As an example, I'd want: united states conference on lung cancer to become United States Conference on Lung Cancer.

Is there a way to do this?