Thousand Separators in the Number field is failing conversion to number or float

We have external generated CSV Files that has numbers with thousand seperators. Dremio identifies them correctly when in string format. But, changing their data type to Number or Float fails to convert them proprely. (Plz. refer below screenshot)

Number fields with thousand separators are not being parsed correctly and failing to convert to float.

Is there any parameter that can be passed to CONVERT_TO_FLOAT() function that allows it to parse thousand separators correctly?