Help with simple conditional?

Fairlight fairlite at fairlite.com
Thu Aug 16 01:06:44 PDT 2012


Thanks to everyone who responded (pretty much everyone offlist for whatever
reason...).

I found the problem, although Ken White nailed it right after I figured it
out.  I tried replacing the second argument to INSTR() with a literal
string "DARK" and it started working.  It then dawned on me to push the
spaces out of the variable when replacing it:

instr(SinUp,SearchUp)

...became:

instr(SinUp,""{SearchUp{"")

That solves the problem, and it would probably work with 'co' as well, once
the second string doesn't have ("70" - len(SearchUp)) spaces trailing after
the actual intended string.

I knew the logic was sound...had to be something in the data.  A few hours
away did a world of good.

Thanks again!

mark->


More information about the Filepro-list mailing list