I am using the Contact Selector control to pull names from a SharePoint user list. The names are populated as Doe, John K. I have a concat formula in a text box to make the name appear as John K Doe. My problem is the Contact Selector adds an unnecessary space after the name so my text box begins with a space in front of the first name so I get " John K. Doe" instead of "John K Doe". Is there a way to use concat and trim to remove the extra space?
My text box formula is: concat(substring-after(DisplayName, ","), " ", substring-before(DisplayName, ","))