How can I search for a string that begins with a certian word? 2

[tctran]

Hello,

I have a list of about 75 different types insulin medications and would like to query the report to look for records with medication that begins with a combination of either “INSULIN”, "Insulin" or "insulin". How can this be done in Crystal Reports?

Thank you so much in advance for any help you can provide!

Best regards,
TC

 

[kray4660]

left({somefield}, 7) = “INSULIN". This assumes your DB is case-insensitive, If it is not, you can use the UCASE function around the field.

 

[BettyJ]

Uppercase({YourField}) startswith "INSULIN

 

[tctran]

BettyJ & kray4660,

Thank you so much for the tips! I really appreciate your time.

Best regards,
TC

 

[tctran]

What if I want to search for the combination uppercase and/or lower case like "INSULIN", "Insulin", or "insulin"? Is there a function to look for the string regardless of the case instead of typing out all of the possible combinations? Thank you again for all of your help!

TC

 

[BettyJ]

If you have
[tt]Uppercase({YourField}) startswith "INSULIN"[/tt]
in the Record Selection Formula in Crystal Reports, you should be getting all the records you are looking for if it always starts with any case combination of the word "insulin" since the function uppercase will convert the values to uppercase and then compares it to "INSULIN".

If not then also try
[tt]ltrim(Uppercase({YourField})) startswith "INSULIN"[/tt]
to eliminate any blank spaces in the beginning of the medication.

If you are still not getting all the records you are looking for, please post sample data from the table.

 

[tctran]

Betty,

Thank you for the tip! I've got to try this out. I really appreciate all of your help!