Wildcard facility causes problem in arraysearch( function


#1

I have a need to do an arraysearch( for a text item containing a question mark. The problem is, the question mark is interpreted as a wildcard, so it matches stuff that I don’t want it to.

Is there a way to disable the wildcard (ideally, it should be an option)? I can probably find a work-around if need be.


#2

If you convert the array into a data array, arraysearch( doesn’t allow wildcards in a data array (this is documented, I just looked it up). Here’s an example:

arraysearch(importdataarray(originalarray,separator),"searchfor",1)

In fact, the last parameter is optional when using a data array, so if you are searching the entire array, you can leave that parameter off entirely.

arraysearch(importdataarray(originalarray,separator),"searchfor")

#3

Good one Jim - I missed that subtle difference.