Selecting part of a string for parameter 3

[strom99]

Hi

Need some help here, trying to set a parameter based on a product field, where the user can type in the product number (i.e. FC-104) which is contained in a 255 Character String. Anybody have any ideas?

Thanks
X-)

 

[kenhamady]

Trev,

Need a bit more info. Check the FAQ on what to include with the question. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[strom99]

OK here is an example of my field

'XX(TM) XXXXX XXXXX(TM) XXXXXX XXXX XXXXXXX XXXX FC-786F'
OR
'XX(TM) XXXXXXXX(TM) XXXXXX XXXXXXX S15'

When the user is prompted they need to be able to type in 'FC-786F' or 'S15' and bring up the entire field. All the fields are of different lengths with the product ID (FC-786F) being quite different also, but always at the end of the field. Is this possible.

Thanks for the help.

 

[MalcolmW]

The InStr function is probably what you want to look at. I think Ken was trying to find out what version number of SCR you have, because the InStr function is not present in all versions.
For faster, more precise answers, at least include your version number. Malcolm
Remember, if it wasn't for electricity, we'd be surfing the net by candlelight.

 

[strom99]

Version 8

 

[MalcolmW]

What build?
Just kidding - that's not nearly as challenging as someone using v2. The InStr function will tell you where the first occurance of the first character of a search string occurs in a target string. If result is 1 or greater, then the search string is in the target string. Malcolm
Remember, if it wasn't for electricity, we'd be surfing the net by candlelight.

 

[malk]

You can use the "mid, left, or right" formulas based on where in the string the part of data you want is

 

[kenhamady]

The only problem with InStr is that you might find a match in the middle of the string. To just check the end I would use Right:

Right({field}, Length({?Param})) = {?Param} Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[dcm]

Strom99: As you have v8 you also have the InStrRev function - does exactly what you want - searches the string from other end i.e. S15 would return 3 David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner