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