Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X
I'm trying to use the "match" function and having a very ridiculous problem. If there is no match, the function returns error. Works fine if there is a match. This makes it useless. As best I can tell from the documentation the return should be "-1" if there is no match. What obvious thing am I missing?
Solved! Go to Solution.
Please point me to the location where it says that upon no match the function returns -1.
As far as I know, the reaction upon no match has always been an error.
Note that -1 is not a logic indication for no match, because you could set ORIGIN:=-1, which might mean that returning -1 the value was found at the first position. On the other hand, returning any (scalar) value should mean there's something wrong, because match is supposed to return a vector with the indices/positions (as you can see in the first example); but NaN could be another choice. However it was chosen to return an error in such cases.
If you want to get -1 upon no match, you'll have to write your own match() function, or embed it in a program where you trap the error:
Success!
Luc
Please point me to the location where it says that upon no match the function returns -1.
As far as I know, the reaction upon no match has always been an error.
Note that -1 is not a logic indication for no match, because you could set ORIGIN:=-1, which might mean that returning -1 the value was found at the first position. On the other hand, returning any (scalar) value should mean there's something wrong, because match is supposed to return a vector with the indices/positions (as you can see in the first example); but NaN could be another choice. However it was chosen to return an error in such cases.
If you want to get -1 upon no match, you'll have to write your own match() function, or embed it in a program where you trap the error:
Success!
Luc
@MR_10595556 wrote:
I'm trying to use the "match" function and having a very ridiculous problem. If there is no match, the function returns error.
You may not like this behaviour and may think that different one would be more appropriate, but I won't call this ridiculous.
This makes it useless.
I disagree, Would you also say the the implemented division operator is "useless" just because it throws an error when trying to divide b zero?
Error trapping is up to the user.
As best I can tell from the documentation the return should be "-1" if there is no match.
No! This is not the case and never was. Maybe you confuse the "match" function for vectors and matrices with the "search" function for strings!?
As Luc already suggested you may redefine the match function to return something meaningful if no match is found. That way you may have more control to react accordingly.
In Prime it may look like this:
Personally I would prefer a NaN as return value if no match was found.
Note that the built-in "match" function has an optional third argument -> Lookup Functions
When you type "match" your (re)defined function is used and it will throw an error if third argument is used.
You still can use the built-in function if you label the word "match" as being "Function":
Note the different typeface.
Of course you could also redefine the match function with the third argument:
So whenever you need the match function with its third argument, use the capital M, otherwise the lower case.
You may hide the redefinition of the functions at the top of the sheet - either in a collapsed region or in the non-printable area to the right of the right margin.
Sorry if I offended. After reading the MathCAD help, documentation, searching the online community, and finally asking Chat GTP (that is where the -1 idea came from), I did not find any place that said the function returns "error" on no match. That might be obvious for people very close to it, but I suggest it needs to be stated explicitly because there are many platforms that have match functions and at least for me the idea that the result of no match is an error I have to write a handler for is outside of my experience. Just adding "the function returns "error" on no match" to the definition of the match function in the help file would have been an enormous help, especially since it is a different behavior than many people like me would expect from this function.
You did not offend and you sure a right that the documentation has (much) room for improvements.
ChatGPT does not know much about Prime - after all Prime is not a mainstream software like MatLab or Maple.
Hi @MR_10595556,
I wanted to follow up with you on your post to see if your question has been answered.
If so, please mark the appropriate reply as the Accepted Solution.
Of course, if you have more to share on your issue, please let the Community know so that we can continue to help you.
Thanks,
Anurag