Crystal Reports 10 - wildcard search... 1

[Crazycritter1]

Hi there - I have a field of set length, that I need to be able to search for 8 sets of 3 character lenght combinations. The character strings are not uniformly located at any position within the field.

What is the best way to attack this situation? I am VERY new to Crystal 10, and only have about 2 weeks worth of hands on learning...

Any assistance is appreciated!!

Thanks!!

 

[rosemaryl]

Dear Crazycritter1,

Why don't you post examples of the string, it's contents and what you need to search on ...

regards,
ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[lbass]

What do you want to do once you have identified a field as meeting your criteria? If you want to select the field if it meets one of these criteria, then you could create a selection formula like:

instr({table.string},"ABC") > 0 or
instr({table.string},"BCD") > 0 or
instr({table.string},"CDE") > 0 or//etc.

-LB

 

[Crazycritter1]

I'm using Crystal Reports 10 with an SQL Database...

The field I'm needing to filter is 10 characters in length.

An example of Content:

TAT 0873ES
0873 BUS D
D ES 0153
ES ORG EMP
MGTESBRD D

I need to be able to exclude any records that contain any ONE of the following codes, which are currently located within any point of that string:

ES, TAT, ORG, BUS, EMP, TST, BRD, MGT

I'm having trouble with the fact that any record could have multiple occurances of these codes, and that the locations aren't standard.

For example the string above "MGTESBRD D" - the first occurance of any of the 3 MGT, ES, BRD would have excluded the record from my report.

Will that example lbass left, analyze the string, based on the text, regardless of it's location?

Please let me know - and thanks again for the help!!!

 

[Crazycritter1]

Disregard my last post... The suggestion by lbass worked like a charm.... Thanks again to Rosemary as well!!

I appreciate the assistance!!