Underscores ignored in selection formula string

[systechusa]

Hello -

I have created the following selection formula:

not ({RESULTS.ANALYSIS} startswith ["$S_", "S_"])

The reason I have created this formula is because I want to exclude such values as "$S_QUECHERS" and "S_NICOTINE".

The problem is, when I run the report, such values as "$SCREEN_LCMSMS" and "SUGAR" are also excluded, even though they do not start with "$S_" or "S_".

I would appreciate any help. Thank you in advance!

 

[Turkbear]

Hi,
Depending on the database, the _ character can be interpreted as a wild card ( for a single character while * is for a string of chars) - that could cause the result you are seeing.

What database is involved?




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[systechusa]

Thank you very much for the reply. We are using a SQL2000 database, and it certainly does seem as though the underscore is being treated as a wildcard. I really hope there is an easy workaround available... Do you have any suggestions?

 

[lbass]

You could create a formula {@analysis} like this:

if {RESULTS.ANALYSIS} startswith ["$S_", "S_"] then
"^" else
{RESULTS.ANALYSIS}

Then use a record selection formula like this:

{@analysis} <> "^"

-LB

 

[systechusa]

Thank you lbass! That was embarrassingly simple, and it saved me a lot of grief Cheers!