<div>
so you saying that the single field contains literally...<br />
LBS Customer # LEX123LBS Proposal # 101508_P3LBS QuickBooks Order # 4428LBS Customer PO # 4500044904<br />
<br />
So can LBS always be used to denote the start of a 'section' ?
</div>


<div>
Yes LBS can always be used to denote the start of the section.<br />
<br />
When you view this field in crystal it shows as this<br />
NOTE_TEXT<br />
LBS Customer # LEX123<br />
LBS Proposal # 101508_P3<br />
LBS QuickBooks Order # 4428<br />
LBS Customer PO # 4500044904<br />
They have return characters which moved them to different lines. &nbsp;They do not show like you presented above. &nbsp;I hope this helps.
</div>


<div>
mlmcc,<br />
<br />
The first formula Split({NoteField},chr(13))<wbr /> I get an error THE RESULT OF A FORMULA CANNOT BE AN ARRAY.<br />
<br />
The second forumula works except that it shows as follows and I need everything on the first line. &nbsp;An example is if I use this formula Split({NoteField},chr(13))<wbr />[2]<br />
<br />
NOTE_TEXT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Outcome Displays like this<br />
LBS Customer # LEX123 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blank<br />
LBS Proposal # 101508_P3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LBS Proposal # 101508_P3<br />
LBS QuickBooks Order # 4428 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blank<br />
LBS Customer PO # 4500044904 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blank<br />
<br />
I need data to show like this in a single line:<br />
<br />
LBS Customer # LEX123 &nbsp; &nbsp; LBS Proposal # 101508_P3 &nbsp; &nbsp; &nbsp;data3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; data4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />

</div>


<div>
Once you have done the split you have the items in your array, if you assume the results will always be in the same order you could have 4 seperate formulas but use your variable as result[1] to result[4] as the last statement.
</div>


<div>
After thought you need to create your formula as follows: <br />
<br />
stringvar array Result;<br />
Result:= split({notefield}, chr(13));<br />
Result[1]<br />
<br />
Repeat this replacing the array part each time...
</div>


<div>
watsonj,<br />
<br />
I get the same information as mlmcc. &nbsp;The fields show with the carriage returns. and display like on two different lines. &nbsp;See the snapshot in crystal.<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2009/03_w10/112575/Book1.xls" target="_blank" class="file-inline" title="Snapshot of the crystal report (62 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Book1.xls</a>
</div>


Book1.xls

<div>
The correct answer is return character with a new line<br />
<br />
You can get at each field individually to display them<br />
Split({NoteField},chr(13) &amp;chr(10))[1]<br />
<br />
I am giving all points to mlmcc since watsonj answer was basically a duplicate of mlmcc.<br />
<br />
Thanks for the help.<br />

</div>


<div>
<div class="content wysiwyg-content">
NOTE_TEXT<br />
LBS Customer # LEX123<br />
LBS Proposal # 101508_P3<br />
LBS QuickBooks Order # 4428<br />
LBS Customer PO # 4500044904<br />
<br />
I was thinking four formulas and putting them on the report but do not know what the formula's would be. &nbsp;Any advise to segragate this entire text field to four columns? &nbsp;The database is oracle and beginning titles are in the string field are consistent each time.<br />
<br />

</div>
</div>


NOTE_TEXT
LBS Customer # LEX123
LBS Proposal # 101508_P3
LBS QuickBooks Order # 4428
LBS Customer PO # 4500044904

I was thinking four formulas and putting them on the report but do not know what the formula's would be.  Any advise to segragate this entire text field to four columns?  The database is oracle and beginning titles are in the string field are consistent each time.



How to make the following string field with return characters as four separate columns

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.