Newbie Questions

Re: Capitalize first letter of all words

Jimmy — Thu, 26 Mar 2015 15:13:12 GMT

You can find the file by going to the Data tab and clicking on Resource Files.

You can add it to your own form by doing:

Data Connections
Add...
Next >
XML document
Next >
Resource Files...
Add...
(Select file)
Next
Finish

Re: Capitalize first letter of all words

merlyn333 — Thu, 26 Mar 2015 15:09:42 GMT

Hello Jimmy: Wow! I think I have to study much more as I'm a newbie in this topic. I still not know what is the "Iterator.xml" and where to find it. Very complex for me. I'll study and I'll try follow the steps you provided to me. Thanks!

Re: Capitalize first letter of all words

Jimmy — Thu, 26 Mar 2015 14:42:47 GMT

Hi Julian,

I'm attaching a form that demonstrates how you can do this. The technique is a little tricky, but you can add the functionality to your own form by doing the following:

Export the Iterator.xml file from the form's resource files
Add it to your own form as an XML file data source
Copy over the rules from the Iterator data source's start and trigger fields. To save you some hassle with modal dialogs and, here are the rules and formulas:

start field:

Rule: Copy value to first
Set first/@remainder to . (current field)
Rule: Trigger operation
Set step/@trigger to (blank)
Set step/@trigger to "go"
Rule: Determine result
Set @result to substring(xdMath:Eval(xdMath:Eval(../step/@value[. != ""], 'concat(" ", .)'), ".."), 2)

trigger field:

Rule: Process values
Condition: @trigger is not blank
Set @remainder to substring-after(../preceding-sibling::*[1]/@remainder, " ")
Set @value to substring-before(concat(../preceding-sibling::*[1]/@remainder, " "), " ")
Set @value to concat(translate(substring(../@value, 1, 1), "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), substring(../@value, 2))

If done correctly, any time you set a value to the start field, the result should be deposited in the result field.

Capitalize first letter of all words

merlyn333 — Thu, 26 Mar 2015 14:26:18 GMT

Hello James: After reading the post "Format text with proper case in InfoPath" (http://goo.gl/FV3YAH), I found that this solution capitalize the first letter from the first word, but I need to capitalize the first letter from all words like "This Is A Test". Could you guide me with the script to do so? Thanks in advance.