I'm requesting help to accomplish the extraction of a string based on the discovery of a variable, using Crystal Syntax.

My report contains part #s, shown in the left column:

45567P1                 P1
89933-01               -01
1R456X1                 X1
B8821C621R101     R101
G46-311               -311

I need to display a certain section of the part numbers which are shown in the right column above (P1, -01, etc.). The extraction comes from the right side of the part number.

So the logic is, reading each part # right to left, to display everything to the right of the first alpha character or "-" encountered. In the case of "-" the dash needs to be displayed.

I'd greatly appreciate the assistance in getting this done. I'm just not advanced enough yet in CR to figure this out . . . though I sure have tried.
- Aaron in Englewood Colorado





Edited by aaron80126 - 21 Sep 2016 at 3:49am

Thank you for your response. I tried the formula you sent (modified for my table/field name):

right({OrderDet.PartNo}, revinstr({OrderDet.PartNo}), not(isnumeric({OrderDet.PartNo})))+1)

but I get the error message:

"A number, currency amount, boolean, date, time, date-time, or string is expected here." (revinstr is highlighted).

I tried the formula in both formula workshop and select expert but same error message. Any idea what could be causing this?
- Aaron

I got the parans match correctly now (thats what I get for just trying to remember function names).

right({OrderDet.PartNo}, revinstr({OrderDet.PartNo}, not(isnumeric({OrderDet.PartNo})))+1)

I need to re-think this (I really need more sleep).  Basically I have to search from the end of the string until I hit a non-numeric (loop?), then only strip off that part of the string.  For some reason I was trying to use InstrRev, but a alpha characters is throwing me off.

The following code does work (I actually tested it :-)

Just replace thefield with your field.

numbervar i :=len(thefield);
while isnumeric(mid(thefield,i,1))  do ( i := i -1);
mid(thefield,i)