General

Re: Upper case all data

cmoses0971 — Thu, 06 Oct 2011 14:13:21 GMT

That worked great CycleFitness... That was all I needed as well. :) Works great!

Re: Upper case all data

CycleFitness — Tue, 25 Apr 2006 18:44:31 GMT

Matt:

I just followed your links and see it's JScript. How do you attach that to the field?

Deb

Re: Upper case all data

CycleFitness — Tue, 25 Apr 2006 18:42:32 GMT

Oh, boy. Thanks, Matt. You guys are way over my head! I'm assuming that's all through code??? If so, what language is that?

I did come up with a solution for each of the three as follows:

1) Convert all to uppercase:
translate(., "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ")

2) Convert first letter to uppercase:
concat(substring(translate(., "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1, 1), substring(., 2, string-length(.) - 1))

3) Format a telephone number as 999 999-9999:
I adapted S.Y.M Wong A Ton's solution for formatting a time field found here: http://enterprise-solutions.swits.net/infopath/auto-format-time-on-lostfocus.htm.
He was so taken with the idea of using it for telephone numbers that he's re-thinking the solution and will post it as a new receipe this weekend.

I will also save what you've posted as an example of doing it with code, correct? ;-)

Re: Upper case all data

Matt Faus — Tue, 25 Apr 2006 01:46:28 GMT

Try doing something like this in the OnAfterChange of each of the nodes:

eventObj.site.text = eventObj.site.text.ToUpper();

This would make the text all uppercase, but for number 2 you would do this:

var text = eventObj.site.text;
text = text.substring(0,1).ToUpper() + text.substring(1, text.length);

eventObj.site.text = text;

Using these similar techniques you can create option 3. I hope this helps!

REF:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/9cf9a005-cbe3-42fd-828b-57a39f54224c.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/9cf9a005-cbe3-42fd-828b-57a39f54224c.asp

Re: Upper case all data

CycleFitness — Mon, 24 Apr 2006 19:11:42 GMT

I would like to do this as well as the following:

1) Convert a state field to all upper
2) Initial cap the first letter of a field
3) Format a telephone number field as: (999) 999-9999

The string.ToUpper() function is something that has to be done through code? Where do I find help on these functions?

Thanks!

Re: Upper case all data

jeanpaul — Mon, 08 Aug 2005 21:00:55 GMT

I am not sure where and how to implement the string.ToUpper() function...ar you suggesting to aplly to every node or there a way to apply to all nodes...sample code would help...thanks

Re: Upper case all data

Agni Jonnalagadda — Mon, 08 Aug 2005 20:36:35 GMT

Hi jeanpaul,
Directly in InfoPath there is no such method, but as you said you can use translate. Other way is write a funtion to convert data to uppercase by using string.ToUpper() function.

Agni
InfoPath Dev India

Upper case all data

jeanpaul — Mon, 08 Aug 2005 20:14:25 GMT

Is there a way to upper case all the input in a form, instead of having to apply the translate function to every field in the form.