<div>
Both are good answers.<br />
<br />
mlmcc
</div>


<div>
Thank you...I will use the above suggestions.... this project has been set back, but I can use the above suggestions.<br />
<br />
THANKS
</div>


Thank you...I will use the above suggestions.... this project has been set back, but I can use the above suggestions.

THANKS

<div>
<div class="content wysiwyg-content">
Experts:<br />
<br />
Can you tell me the formula to use in order to extract the characters found in the SECOND TO THE LAST number in this type of string?<br />
<br />
N_1051010_98_822<br />
N_1050815_2_14<br />
<br />
<br />
In this above example I need to extract the &quot;98&quot; and the &quot;2&quot; in the above 2 examples. It would always be the number (1-3 digits) immediately BEFORE the last &quot;_&quot;<br />
<br />
What I will more than likely needing to do is LINK one table that contains this NUMBER to another table that has the number is a more normal format of 98.<br />
<br />
ie.<br />
<br />
TABLE 1<br />
<br />
DATE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CODING<br />
01/01/05 &nbsp; &nbsp; N_1051010_98_822<br />
01/05/05 &nbsp; &nbsp; N_1050815_2_14<br />
<br />
TABLE 2<br />
<br />
DATE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BATCH<br />
01/01/05 &nbsp; &nbsp; &nbsp;98<br />
01/05/05 &nbsp; &nbsp; &nbsp; 2<br />
<br />
I'm needing to LINK TABLE 1 (CODING &quot;Extract&quot; number ie. 98) with TABLE 2 &nbsp;BATCH number field.<br />
<br />
How can I first of all extract the number, then if possible use the extract to LINK the two tables???<br />
<br />
Thanks<br />
Mike<br />
<br />

</div>
</div>


Experts:

Can you tell me the formula to use in order to extract the characters found in the SECOND TO THE LAST number in this type of string?

N_1051010_98_822
N_1050815_2_14


In this above example I need to extract the "98" and the "2" in the above 2 examples. It would always be the number (1-3 digits) immediately BEFORE the last "_"

What I will more than likely needing to do is LINK one table that contains this NUMBER to another table that has the number is a more normal format of 98.

ie.

TABLE 1

DATE          CODING
01/01/05     N_1051010_98_822
01/05/05     N_1050815_2_14

TABLE 2

DATE          BATCH
01/01/05      98
01/05/05       2

I'm needing to LINK TABLE 1 (CODING "Extract" number ie. 98) with TABLE 2  BATCH number field.

How can I first of all extract the number, then if possible use the extract to LINK the two tables???

Thanks
Mike



Extraction Formula Help

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.