Jump to content

StrToFloat () all combinations of decimal separator and lang. settings

Recommended Posts

On 8/17/2021 at 1:48 PM, Lars Fosdal said:

I was working with various kinds of financial data, weather data and power data (prices, volumes, etc), and thousand separators usage was variable. Spaces, commas, dots, the lot.

It was a hodge-podge of formats since very few standard exchange formats existed at the time.


Even vendors that you had contractual agreements with, would change the format on the fly, without notice. 
"Yeah, we changed the format. Nobody told you?"

Yes i have had the same, with invoice recognition software i wrote. And then you have the suppliers where the financial formats differ from the "data/content" format.

So we had a base setting for the numeric formats per application, per supplier (inherited),  per content fields/table (inherited). 

Edited by mvanrijnen

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now