Newbie Questions

Re: how to correct address to upper case

Hilary Stoupa — Fri, 19 Sep 2008 21:40:54 GMT

You could try substring-after to get the word after the space:

substring-after("main street", " ")

will return "street", for example.

So, using your formula above, if the value of the current node is "main street":

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

should return "Street". Mind you -- I didn't test the above formula, just replaced the '.' character with 'substring-after(., " ")'.

That being said, how will you handle addresses with more than two words? Like if it is West Main Street?

Re: how to correct address to upper case

johnmacd — Fri, 19 Sep 2008 19:27:15 GMT

I think I'm on the right path, but I'm still stuck and hope someone can help out. I have found that the following forumula will translate the first letter of the first word to an upper case.

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

ie main street becomes Main street

How can I get it so both words are changed to upper case?

how to correct address to upper case

johnmacd — Fri, 19 Sep 2008 15:04:20 GMT

I'm using InfoPath2003

How would I go about correcting an address to use upper case letters?

ie correct 123 main street to 123 Main Street

TIA