https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/101048.aspxFri, 06 Feb 2015 19:30:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101048donstephen0https://www.infopathdev.com:443/forums/thread/101048.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101048<p>Hi Blake,<br /><br />I&#39;m not sure how your form is set up so I am unable to provide with a formula (not sure if you are concatenating multiple fields or fields from a repeating table). If you are using multiple fields, I would suggest using a substring logic which only returns data if the field is not blank (<strong>field1 != &#39;&#39;</strong>). For repeating data, you will need to use a double eval technique and use the same filter where the field is not blank. I hope this makes sense.<br /><br />Regards,<br /><br /></p>https://www.infopathdev.com:443/forums/thread/100910.aspxTue, 27 Jan 2015 15:02:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:100910BlakeT0https://www.infopathdev.com:443/forums/thread/100910.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=100910<p>Hi all, </p> <p>I&#39;m pretty new to InfoPath 2010 and am struggling to concatenate all my &#39;not blank&#39; text fields into one tidy, readable format.</p> <p>I&#39;ve soted the line break, but I don&#39;t want my formula to add&nbsp;the line break&nbsp;when a field is empty.</p> <p>I&#39;d quite like them to be presented one line per populated text box.</p> <p>i.e. </p> <p>text 1</p> <p>text 2</p> <p>text 3</p> <p>etc</p> <p>Is this possible?</p> <p>&nbsp;</p> <p>Thanks</p> <p>&nbsp;</p>