Help with a String Formula

[3dservices]

I'm exporting the data from access but I need to manipulate it in the report.
Example: I'm exporting the data SHOE S8-1-A-2" but I need to extract the text "SHOE " for the report. I've tried using the following formula but haven't had any luck:
If InStr({Piping.LONG_DESCR}, "SHOE&quot Then
Trim({Piping.LONG_DESCR});
Mid({Piping.LONG_DESCR},6)

I'm new to programming with Crystal Reports so any help would be appreciated.

 

[dgillz]

Instr() is not purely a boolean returning either true or false, Instr() returns the character number where your substring begins, or zero if it is not found. So, try this:


If InStr({Piping.LONG_DESCR}, "SHOE&quot>0 Then Mid({Piping.LONG_DESCR},Instr({Piping.LONG_DESCR},),"SHOE",6)

This should also take care of any leading spaces that your trim() function woudl have done for you.

Let me know how this works.

Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[synapsevampire]

if left(trim({Piping.LONG_DESCR}), 4) = 'SHOE' then
trim(Mid({Piping.LONG_DESCR},6))

You can also use the instr() and mid() functions like this for future reference:

If InStr({Piping.LONG_DESCR}, "SHOE&quot Then
trim(Mid({Piping.LONG_DESCR},InStr({Piping.LONG_DESCR}, "SHOE&quot+1))

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[synapsevampire]

Ooops, forgot the >0 on the instr, thanks dgillz.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com