TEXTTONUMBER checks invalid decimal point PLAT-42852

Support, Troubleshooting, & Help
1

Hi guys,

after updating to LTS14 we realized that the function TEXTTONUMBER now checks the validity of string as input. However, we use the decimal point in german version, e.g. for TEXTTONUMBER(500,00) we become a warning. Does this function also consider the language specific settings? It is related to PLAT-42852.

Thanks,
Haochen

2

Haochen,

Thanks for bringing this up.

In LTS14, TEXTTONUMBER() only accepts strings with a dot as the decimal separator. It doesn’t support locale-specific formats like commas. So TEXTTONUMBER(“500,00”) will return a warning.

You can fix this by replacing the comma before conversion.