Error message is an error itself

Hello Codans,

The following is no big deal, but perhaps confusing for users. There are a few instances where the code editor indicates an error while the formula does what it was meant to do. It is usually a matter of rewriting the formula or leaving things out, since the ‘wrong’ code actually does some useful things.

Here is one example of code that works fine- if you need more samples then I will collect some more.

image

I use this formula the way it is written because it happens rather frequently that data collected through forms or conversions has a space to many in front or behind the data. In my case, the data in either table can have to many spaces and this way we can still find what we are looking for.

Not really a bug, but perhaps fixable to not show up as an error.

Greetings,
Joost

1 Like