<div>
Yep...that was it! &nbsp;<br />
Thank you.<br />
Can you explain what is happening with this code:<br />
<br />
&nbsp; Left({YourString},ParenLoc<wbr />-1)<br />
<br />
Thank you.
</div>


Yep...that was it!  
Thank you.
Can you explain what is happening with this code:

  Left({YourString},ParenLoc-1)

Thank you.

<div>
Left(String,Length)<br />
<br />
It takes the first length characters of the string.<br />
ParenLoc has the position of the ( so you want the characters upto but not including that one thus the need to subtract 1<br />
<br />
mlmcc
</div>


Left(String,Length)

It takes the first length characters of the string.
ParenLoc has the position of the ( so you want the characters upto but not including that one thus the need to subtract 1

mlmcc

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
Can you help me with string manipulation?<br />
I would like to take this string:<br />
English Language(2)<br />
and take of the everything to the right of the parenthesis so the string looks like this:<br />
English Language<br />
I have made a few attemps with no luck.<br />
Any help you can provide would be appreciated.
</div>
</div>


Hello Experts,
Can you help me with string manipulation?
I would like to take this string:
English Language(2)
and take of the everything to the right of the parenthesis so the string looks like this:
English Language
I have made a few attemps with no luck.
Any help you can provide would be appreciated.

trim ( off string

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.