InfoPath Dev

 hi

 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

 

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 about this?:

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

 hmmmm

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

 

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?