Data loss when sorting
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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIt'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
------------------------------
The data is coming in from an Oracle database as text. It looks like there are more data issues in this table. It's odd that I am having issues in this table but not other tables that rely on the same data.
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------