General

Re: Capitalize the first letter of every word?

fhall — Thu, 14 Jun 2012 18:15:46 GMT

Thanks for the sample - very helpful!

In trying to find a true Title Case ruleset, can anyone (Ernesto?) give an example of something like this?
plain-text logic (apologies) might be:

replace "letter.space.lower-case-letter" with "letter.space.upper-case-letter"

I'm more familiar with RegularExpression, so maybe this isn't possible in InfoPath (of course, no code allowed).

how about adding just one more iteration to this, allowing capitalization of 3 words.
I'd appreciate a working example - i'm terrible with making/editing these.

using the 2nd part of your example (capitalize 2nd word) as the starting point, how do we separate the next/3rd word group?

concat(substring-before(., " "), " ", translate(substring(substring-after(., " "), 1, 1), "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), substring(substring-after(., " "), 2, string-length(.) - 1))

possible to have case sensitive substring-before?

concat(substring-before(., " lowercase-letter"), ...

or to find third word sequentially?

concat(substring-before(., " * "), ... *=non-space repeated 1+

many thanks for your patience and all this sites previous assistences.

cheers,

Re: Capitalize the first letter of every word?

ErnestoM — Fri, 15 Apr 2011 12:26:47 GMT

I got it working with two words (one space) in the field. I'm attaching a sample form.

Perhaps you can try to extend this to two spaces or more and let us know if you find a formula?

Thanks!

Re: Capitalize the first letter of every word?

shniggens — Wed, 13 Apr 2011 20:55:18 GMT

Any tips on how I would combine that with my existing formula? Also, what if there is more than one space?

Thanks!

Re: Capitalize the first letter of every word?

ErnestoM — Mon, 11 Apr 2011 14:13:30 GMT

What if you also translate the first letter than comes after a space? You would need to use something like substring-after to locate that letter.

Capitalize the first letter of every word?

shniggens — Sun, 10 Apr 2011 23:21:42 GMT

I've found the solution to capitilize the FIRST word of the text box -

translate(substring("field", 1, 1), "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), substring("field", 2, string-length("field") - 1)

But what if you want to capitalize the first letter of EVERY word in the text box?

I have a city text box that I want to do this with, so that San Diego will be correct, and not San diego.

Any thoughts?

Thanks!