Controls

Re: how to concat or translate a whole string instead of a single char?

Jimmy — Thu, 14 Jun 2012 14:56:31 GMT

As I've already said, InfoPath doesn't have a good built-in solution for that scenario. The best suggestion I can give you is to give qRules a try. Is your form a list-based form or a general-purpose form that interacts with a list?

Re: how to concat or translate a whole string instead of a single char?

luqmansky — Thu, 14 Jun 2012 14:02:54 GMT

hmmmm

what if we don't know how many spaces may appear in a string.

Re: how to concat or translate a whole string instead of a single char?

ErnestoM — Thu, 14 Jun 2012 13:27:41 GMT

How about this?:

concat(substring-before(field1, " "), "%20", substring-after(field1, " "))

Re: how to concat or translate a whole string instead of a single char?

Jimmy — Thu, 14 Jun 2012 13:25:27 GMT

InfoPath doesn't provide a good way to do this, which is why we added it to qRules. qRules' ReplaceString command can replace multicharacter parts of strings with other multicharacter parts (e.g. replacing " " with "%20"), but even better in your case would probably be the Encode command, which can URL encode the whole string, taking into account everything that needs to be encoded rather than just spaces.

how to concat or translate a whole string instead of a single char?

luqmansky — Thu, 14 Jun 2012 09:41:09 GMT

i have created a customized a form in infopath for sharepoint list.

In that i have a used a link in which concats from the field and then merge it into the link to make the url.

i want to set the URL.

please help me how to make this string in formula.

string : "InfoPath Form"

required string : "InfoPath%20Form"

how can i do this in formula? :(

i tried to do this using traslate () in formula

translate(""InfoPath Form"";" ";"%20")

it does this : "InfoPath%Form"

please guide me :(

with regards,

Luqman