General

Re: Extra Space on Concatenated Field When Promoted to Sharepoint

Jen B — Wed, 10 Jul 2013 15:30:56 GMT

Thanks Jimmy. I'll try that and publish later this week to see if it worked.

Re: Extra Space on Concatenated Field When Promoted to Sharepoint

Jimmy — Tue, 09 Jul 2013 19:22:50 GMT

It looks like this space is originating from the space in "; ". The substring is stripping off the leading semicolon, but not the space. To fix this, simply change the 2 to a 3.

Re: Extra Space on Concatenated Field When Promoted to Sharepoint

Jen B — Tue, 09 Jul 2013 16:34:30 GMT

Second screenshot

Extra Space on Concatenated Field When Promoted to Sharepoint

Jen B — Tue, 09 Jul 2013 16:20:34 GMT

Hello all,

I have discovered that an extra space is being added in front of a choice when Infopath pushes my concatenated field to sharepoint.

I'm using an IP 2010 filler form published to a MOSS 2007 site.

I have repeating dropdown fields and multi-selection fields setting specific text fields using a concat formula. The text field, when in the form, does not have an extra space, but the field in sharepoint is adding a space in front of the first choice.

The formula on the set concatenation formula is: substring(eval(eval(Operations_Impct_Source[. != ""], 'concat("; ", .)'), ".."), 2)
Where Operations_Impct_Source is the repeating dropdown field.

The text field being set has a formula in the Default Value that is the same: substring(eval(eval(Operations_Impct_Source[. != ""], 'concat("; ", .)'), ".."), 2)

Again, the text field when I look at it in the form, does NOT have an extra space at the beginning. (see attached file) However, when promoted to sharepoint, an extra space is inserted at the before the selection.

Any thoughts?

Thanks!