I have a text field containing a 13 digit number (saved as text). When I customize the report to group or sort on this number some of the fields are converted to scientific notation. The source data is coming from an external database and is coming in as a text field.
What can I do to preserve all of the numbers in the field?
PS. it seems odd to me that some records retain all of the digits while others are truncated into scientific notation.
------------------------------
Paul Peterson
------------------------------
Question
Data loss when sorting
This topic has been closed for replies.
+22It's impossible that a text field suddenly changes to scientific notation. Text is text is text.
It is more likely that the external data coming in via excel is being converted to scientific notation before that corrupted data gets into your app.
If you can look at how the data is created and can prevent it form being in excel format and retain it in CSV format, that could help.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
It is more likely that the external data coming in via excel is being converted to scientific notation before that corrupted data gets into your app.
If you can look at how the data is created and can prevent it form being in excel format and retain it in CSV format, that could help.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.