StrToFloat with Thousand separators

[JoeNg]

StrToFloat does not work with Thousand separators.

Is there a easy way to convert, say, '40,000.00' to real type?

Thanks

 

[whosrdaddy]

one very simple aproach :

//'40,000.00' - > '40000.00
StringReplace(YourfloatStr,',','',[rfReplaceAll);

cheers


--------------------------------------
What You See Is What You Get

 

[JoeNg]

Ah! Simple indeed.

Many thanks.

 

[janchristian]

Another, marginally different variation:

StringReplace(YourFloatStr, ThousandSeparator, '',[ReplaceAll]);

Which version to prefer depends on if the offending string is always created on the same system as your application runs on or if you can be sure that the thousands separator always is a comma and not e.g. a space, or maybe even a dot from a spanish system. In the latter case you have an interesting task of determining which is the decimal separator (",") and which is the thousands separator (".")!
Cheers!

Jan-Christian
Old programmers never die,
they just slowly type away....

 

[JoeNg]

Thanks Jan-Christian

A very good point.