IXLOOKUP is returning incorrect values when searching for the literal string: 'Other...' (Functions/Subroutines/Programs)

The reason for this is that IXLOOKUP was parsing the string and found the BTREE.EXTRACT keyword     which is short form for From..To.  What happens next is that the system will search everything from NULL$ to Other, inclusive.  This happens because  Other   occurs after  Other  and the system was searching for everything from NULL$ to Other not NULL$ to  Other  .

 

To minimize the problem place a  ]  on the end of the string starting  Other ] .  This forces BTREE.EXTRACT portion to look for all strings starting withOther  since the literal string is parsed backwards.

 

For more information on RLIST and BTREE.EXTRACT keywords see the Programmers Reference Manual and the on-line help files for RLIST, BTREE.EXTRACT, Reduce, and Appendix A: OpenList Keyword Reference sections.

 

  • kb/kb_articles/kb0116.txt
  • Last modified: 2024/01/30 13:36
  • by 127.0.0.1