Re: Concat and Removing Unwanted Spaces

griddle — Thu, 25 Feb 2016 16:30:14 GMT

Hilary Stoupa:
Maybe try wrapping your concat in a normalize-space function? normalize-space(concat(field1, " ", field2, " ", field3, " ", field4, " ",field5, " ",field6))

Perfect, thanks!

Re: Concat and Removing Unwanted Spaces

Hilary Stoupa — Thu, 25 Feb 2016 15:42:58 GMT

Maybe try wrapping your concat in a normalize-space function? normalize-space(concat(field1, " ", field2, " ", field3, " ", field4, " ",field5, " ",field6))

Concat and Removing Unwanted Spaces

griddle — Thu, 25 Feb 2016 00:05:07 GMT

Hello, apologies if this has been answered, but I couldn't find exactly what I was looking for.

This is for a web-based form that directly updates a SharePoint list.

I'm looking to concat several text boxes into one. Not all the original text boxes will contain text.

Example:

field1, field2, field3, field4, field5, and field6 need to be concatenated into field7 with a single space between the values.

What I'm using as the formula on field7: concat(field1, " ", field2, " ", field3, " ", field4, " ",field5, " ",field6)

What's happening is that if field1 and field2 and field3 contain no text, when it concatenates fields4-6 into the SharePoint list, there are leading spaces that I don't want to appear.

When previewing the form from design mode, field7 appears to look ok, with no leading spaces if the first several fields don't contain text. The leading spaces appear once the form is published and used in-browser, and in the SharePoint list once submitted.

Thanks!

Newbie Questions

Re: Concat and Removing Unwanted Spaces

Re: Concat and Removing Unwanted Spaces

Concat and Removing Unwanted Spaces