InfoPath Dev

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

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

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

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.

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, '#;')

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

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