Is there a way to use the inverse of either the FIND or INDEX functions ??
For example, a string of characters contains leading blanks and I want to find
the 1st non-blank character in that string.
Trying "INDEX('string',NOT ' ')" or "INDEX(NOT 'string',' ')" yields assembly
errors.
(I've tried both the logical-expression and function-invocation formats of the
INDEX and FIND functions)
Has anyone else successfully used such inverse formats of any of these
functions,
or is there another function (that I can't see) that can yield the results I'm
after.
Best regards, Andre