Re: [basex-talk] Performing extra data conversion for double values (by XQuery)

On 21.04.2022 09:20, Markus Elfring wrote:

I would like to perform a sanity check for some input data which represent numbers that are using the comma as the decimal separator. I stumbled on the message “[FORG0001] Cannot convert to xs:double: …”

Depending on the format of the numeric data it might suffice to use e.g.   . => translate(',$', '.') => xs:decimal() to remove e.g. a $ symbol/currency symbol, to replace the comma with a dot and then to convert the numerical string to an xs:decimal value.