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

Outcomes