https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/96288.aspxTue, 04 Mar 2014 15:45:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:96288Jimmy0https://www.infopathdev.com:443/forums/thread/96288.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=96288<p>This should do it:</p><blockquote><p>concat(Field1, substring(concat(Field2, &quot;&nbsp; &quot;), 1, 2), Field3)</p></blockquote><p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/96286.aspxTue, 04 Mar 2014 15:07:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:96286Koen870https://www.infopathdev.com:443/forums/thread/96286.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=96286<p>Hello,</p><p>I have an InfoPath form with some data connections to SharePoint lists. I concatenate several fields into 1 field. Example:</p><p>Field1 = 45<br />Field2 = 66<br />Field3 = 00</p><p>So concatenated, Field4= 456600</p><p>Sometimes, Field2 is empty. Then I get Field4= 4500. But that&#39;s not what I need, Field4 needs to be 6 characters long! So I want it to be 45&nbsp; 00. Is this possible?</p>