Convert a string to a number in ADO

pabloSB

The venta_neta_euro column in the Transformation View represents a company’s sales at a specific level of detail. Currently, this column is stored as a string, and I need to convert it into a numeric value while keeping the "," as the decimal separator.

I tried using CAST to convert it to FLOAT, but it throws an error because it apparently expects a "." as the decimal separator.

I also tried using the TO_NUMBER function, but I wasn’t able to make it work correctly.

Does anyone know how I can convert this string into a numeric value while preserving the "," as the decimal separator?

I’m attaching a screenshot to clarify

Bhumit285

Hi @pabloSB,

you can try Substitute function for example: CAST(SUBSTITUTE(SUBSTITUTE('YourDataset'.'YourColumn', ".", ""), ",", "."), "FLOAT")

hope this will help!