Controls

Re: How to apply trim() function for values in drop down?

Jimmy — Thu, 07 Jun 2012 17:20:29 GMT

Would you be able to attach your form to this thread so that we can see it?

Re: How to apply trim() function for values in drop down?

chintan.desai — Thu, 07 Jun 2012 17:00:31 GMT

Thx Jimmy for your reply. I did it but triming only applies to 1st item in drop down :(

Re: How to apply trim() function for values in drop down?

Jimmy — Thu, 07 Jun 2012 15:04:23 GMT

Are there any other fields in that data source that you're not using? If so, please try the following:

Add a rule to set the value of the extra field to a value it wouldn't normally have (like "go") after the data is queried (probably a Form Load rule).
Add a rule to that extra field itself like the following:
Condition: FieldToFix contains #;
Action: Set FieldToFix = substring-after(FieldToFix, '#;')

Re: How to apply trim() function for values in drop down?

chintan.desai — Thu, 07 Jun 2012 13:05:31 GMT

Hi qwerty, I tried it, trimming only apply to first item and not all items in dropdown. I wrote rules when form loads. Pls. advice further.

Re: How to apply trim() function for values in drop down?

qwerty — Wed, 16 Mar 2011 18:17:38 GMT

Hi Chintan, yes, you can use the function substring-after(@field, "#;"). It will return contents of the string after the first occurence of "#;".

Re: How to apply trim() function for values in drop down?

Qazi Anis — Tue, 15 Mar 2011 12:52:18 GMT

there is no out of box feature to do so, you will have to do it through code

How to apply trim() function for values in drop down?

chintan.desai — Tue, 15 Mar 2011 12:05:07 GMT

Hi Folks, I had drop down in Infopath which fetch values from Sharepoint List column. Values are coming correctly, but prefix with some junk data. e.g. "20#;CorrectValue1". "20#;" are junk values While research, I got to know that Sharepoint List column is lookup and it is referencing another Sharepoint List column. And junk value are row number in reference List. I mean - "20#;" is the 20th row for 'CorrectValue1' in reference List. Is there any Trim function to trim junk values. If yes, please let me know how to achieve this. Please advice. - Chintan