21 Apr
2022
21 Apr
'22
3:26 a.m.
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.