<div>
Pervasive PSQL doesn't support either SPLIT or INSTR. &nbsp;However, it does have the LOCATE function, which you can use like this:<br />
<br />
LastName --&gt; &nbsp;LEFT( NameField , LOCATE(NameField, ';') -1 )<br />
FirstName --&gt; &nbsp;RIGHT( NameField, LENGTH(NameField) - LOCATE(NameField, ';') )<br />
<br />
Note that the -1 on the LastName field means that if there is NO semicolon in the field, LOCATE returns 0, and a -1 gets passed to the LEFT function, which will likely spawn an error. &nbsp;You may have to do a conditional test for the presence of the semicolon before doing that function call.
</div>


Pervasive PSQL doesn't support either SPLIT or INSTR.  However, it does have the LOCATE function, which you can use like this:

LastName -->  LEFT( NameField , LOCATE(NameField, ';') -1 )
FirstName -->  RIGHT( NameField, LENGTH(NameField) - LOCATE(NameField, ';') )

Note that the -1 on the LastName field means that if there is NO semicolon in the field, LOCATE returns 0, and a -1 gets passed to the LEFT function, which will likely spawn an error.  You may have to do a conditional test for the presence of the semicolon before doing that function call.

<div>
Split function works great! &nbsp;The formula works too but I couldn't immediately figure out how to change the syntax for First Name. &nbsp;Thanks!
</div>


Split function works great!  The formula works too but I couldn't immediately figure out how to change the syntax for First Name.  Thanks!

<div>
Split function works great! The formula works too but I couldn't immediately figure out how to change the syntax for First Name. Thanks!
</div>


Split function works great! The formula works too but I couldn't immediately figure out how to change the syntax for First Name. Thanks!

<div>
<div class="content wysiwyg-content">
I need to split a single database field to LastName and FirstName. &nbsp;The single database field stores the name as &quot;LastName; FirstName&quot; (semicolon is the delimiter). &nbsp;I tried using the split function but it is not working for me. &nbsp;Normally I'd just create a view but this data is coming from a Pervasive database I am not familiar with.
</div>
</div>


I need to split a single database field to LastName and FirstName.  The single database field stores the name as "LastName; FirstName" (semicolon is the delimiter).  I tried using the split function but it is not working for me.  Normally I'd just create a view but this data is coming from a Pervasive database I am not familiar with.

Spllit Name Field

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.