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/90726.aspxSun, 16 Jun 2013 20:38:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:90726Patrick Halstead0https://www.infopathdev.com:443/forums/thread/90726.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=90726<p>Hi Doodguy and welcome,</p><p>Use the substring-before and substring-after functions to extract out what you need. To get the substring before a carriage return, you&#39;ll need to encode the CR-LF (\r\n, &amp;#13&amp;#10) sequence. I can&#39;t remember how to do this, so I just used another multi-line text field (field2) and entered return followed by a delimiter (&#39;#&#39;) and then used substring-before(field2, &#39;#&#39;) as my search for the first substring. For example: substring-before(field1, substring-before(field2,&nbsp;&#39;#&#39;)) will extract the first line before&nbsp;the carriage return for field1 if field2 is set to carriage return plus the sharp (#) symbol. You can play with the text functions to extract other items.</p><p>Good luck!&nbsp;</p>https://www.infopathdev.com:443/forums/thread/90720.aspxSat, 15 Jun 2013 15:38:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:90720doodguy0https://www.infopathdev.com:443/forums/thread/90720.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=90720<p>Hello everyone,</p><p>&nbsp;I have a textbox which users paste data such as &quot;Car make, model, year, etc&quot; as one lump text.</p><p>&nbsp;Can anyone point me in the right direction as to how to pull that apart and take car make throw everything up to a carriage return into a different text box? then do the same for model, again for year, etc.</p>