AnsweredAssumed Answered

Large value numeric field

Question asked by VerneArase on Jul 27, 2017
Latest reply on Oct 24, 2017 by bigtom

I have a database which I use to track IP addresses, and one of the fields it maintains is an aggregate IP address which is represented by a scalar integer value from 0-(2^32-1).


When I export this data, FileMaker considerately exports this value in scientific notation and maintains about five digits of precision.


How do I get FileMaker to export the original value?


If I treat the field as a string, it won't sort properly - which is the whole reason for the field in the first place (since IP addresses as strings don't sort properly).


-- Thanks, Verne