https://www.infopathdev.com:443/forums/43.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/83135.aspxMon, 01 Oct 2012 16:38:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:83135samonenate0https://www.infopathdev.com:443/forums/thread/83135.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=83135Your solution worked perfectly!! Thank you.https://www.infopathdev.com:443/forums/thread/83112.aspxFri, 28 Sep 2012 12:31:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:83112Jimmy0https://www.infopathdev.com:443/forums/thread/83112.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=83112How about changing the first &quot;,&quot; to &quot;, &quot;?https://www.infopathdev.com:443/forums/thread/83091.aspxThu, 27 Sep 2012 16:50:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:83091samonenate0https://www.infopathdev.com:443/forums/thread/83091.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=83091<p>I am using the Contact Selector control to pull names from a SharePoint user list.&nbsp; The names are populated as Doe, John K.&nbsp; I have a concat formula in a text box to make the name appear as John K Doe.&nbsp; My problem is the Contact Selector&nbsp;adds an unnecessary<font size="3"><font face="Calibri"> </font></font>space after the name&nbsp;so my text box begins with a space in front of the first name so I get &quot; John K. Doe&quot; instead of &quot;John K Doe&quot;.&nbsp; Is there a way to use concat and trim to remove the extra space?&nbsp; </p> <p>My text box formula is: concat(substring-after(DisplayName, &quot;,&quot;), &quot; &quot;, substring-before(DisplayName, &quot;,&quot;))</p>