<div>
this is working when &quot;ea&quot; but some are &quot;EA&quot; and this formula is not picking those up. Is there a way to include both options in this formula?
</div>


this is working when "ea" but some are "EA" and this formula is not picking those up. Is there a way to include both options in this formula?

<div>
Use Replace() to replace &quot;EA&quot; with &quot;ea&quot; and apply the same logic as above.
</div>


Use Replace() to replace "EA" with "ea" and apply the same logic as above.

<div>
<div class="content wysiwyg-content">
Crystal formula LEFT - I am trying to return the value LEFT until it find &quot;EA&quot;. &nbsp;I have the below formula but not working. &nbsp;Using example below, I want to return KEL9400<br />
<br />
KEL9400EA<br />
<br />
Left ({FLCMaster.ProductID}, instr({FLCMaster.ProductID<wbr />},&quot;ea&quot;)-1)<wbr />
</div>
</div>


Crystal formula LEFT - I am trying to return the value LEFT until it find "EA".  I have the below formula but not working.  Using example below, I want to return KEL9400

KEL9400EA

Left ({FLCMaster.ProductID}, instr({FLCMaster.ProductID},"ea")-1)

Crystal - Left value until specific character

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.