Data loss when sorting

Question

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
------------------------------

markshnier__you · Answer

It'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
------------------------------

paulpeterson1 · Answer

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
------------------------------

Forum Discussion

Data loss when sorting