Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
5 years ago

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 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
------------------------------
  • 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's avatar
      PaulPeterson1
      Qrew Assistant Captain
      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
      ------------------------------