JSON Reader and NaN values

KNIME Extensions
1

Hello,

I'm stuck with JSON Reader. I want to iterate through a few json files but the problem is that the JSON Reader node can't read NaN values.

ERROR JSON Reader          2:731:764  Execute failed: Non-standard token 'NaN': enable JsonParser.Feature.ALLOW_NON_NUMERIC_NUMBERS to allow
 at [Source: org.knime.base.node.util.BufferedFileReader@7ee58e1d; line: 36, column: 27]

There seems to be an option in BufferedFileReader that could allow NaN  values but there is no such option in the JSON Reader node.

How can I make it work?

 

Thanks Dan

2

According to json.org, NaNs, Infinity, -Infinity are not numbers, so any document containing them without quotes are not valid JSON. (The underlying library -jsonp- does not read numbers as floating point numbers, but as BigDecimals as I remember, which cannot represent NaNs or infinite values.)