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.
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")Good one Jim - I missed that subtle difference.