As it seams number field are systemwide defined as point decimals.
How can i change that?
Whether you see a comma or a period as the decimal point can be controlled with data formatting settings on each layout field via the Inspector's data tab. But when you edit or enter a numeric value, which character you see or enter as the decimal point will be controlled by your computer and FileMaker locality settings.
Yes, i got that too.
The point yesterday was that i got very confused because my fields where simply to short so they often displayed "?" instead of "123.." to indicate that the field is to short. Instead of finding a solution for the import number problem i got puzzled by that issue.
But still i dont find a solution for correctly importing numbers into number fields.
My CSV has information like this: "12345.0" importing this into numer field dont work. As soon i use the inspector to show "Decimal" with fixed lenth of 2 it calculates (shows) something like 123450.
So i used GetAsNumber ( Substitute ( offers_0_.price ;"." ; "," ) ) in the database fields
You are importing CSV data with values like 3,23 and need them to be 3.23? And in your system the period is the decimal symbol?
Its vice versa. I have 1234.1 in .csv and need 1234,1 and in system it seams to be "." (point).
Which is essentially the same issue--the decimal point symbol in the imported data does not match that specified for your locality settings. Just as typing in 3.14 in a field in your database will not result in 3,14 neither will importing 3.14 from a text file.
So you have the solution that I would, in general, set up--import the data as text into a text field and use a calculation to convert the imported text into the needed numeric values.