<div>
What part can be blank?<br />
<br />
Is it the formula @ExtItem or can it have a NULL part?<br />
<br />
mlmcc
</div>


What part can be blank?

Is it the formula @ExtItem or can it have a NULL part?

mlmcc

<div>
It can have a null which is the problem. &nbsp;How would I take care of that in the original formula? &nbsp; Thanks
</div>


It can have a null which is the problem.  How would I take care of that in the original formula?   Thanks

<div>
<div class="content wysiwyg-content">
Here is my formula - (thank you mlmcc) - <br />
<br />
Local StringVar Array strLineParts;<br />
Local NumberVar index;<br />
Local StringVar strOutput;<br />
<br />
strLineParts := Split({@ExtItem},'!');<br />
For index := 2 to UBound(strLineParts) do<br />
&nbsp; &nbsp; strOutput := strOutput &amp;&nbsp;strLineParts [index] &amp;&nbsp;' ';<br />
<br />
strOutput := strOutput &amp;&nbsp;chr(13) &amp;&nbsp;strLineParts [1];<br />
<br />
strOutput <br />
<br />
<br />
I think it is having an issue when the field it blank. &nbsp;I get the array error - I tried adding if (isnull({field}) then &quot;&quot;&nbsp;else the rest of the formula but it is not working. <br />
<br />
Can you help? &nbsp;<br />
<br />
Thank you! 
</div>
</div>


Here is my formula - (thank you mlmcc) - 

Local StringVar Array strLineParts;
Local NumberVar index;
Local StringVar strOutput;

strLineParts := Split({@ExtItem},'!');
For index := 2 to UBound(strLineParts) do
    strOutput := strOutput & strLineParts [index] & ' ';

strOutput := strOutput & chr(13) & strLineParts [1];

strOutput 


I think it is having an issue when the field it blank.  I get the array error - I tried adding if (isnull({field}) then "" else the rest of the formula but it is not working. 

Can you help?  

Thank you! 

subscript must be between 1 and the size of the array -

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.