CSV Export Text Truncated

TWE_Toll · 07-10-2022 03:28 PM

Hi,

I have a csv export setup however when i open the exported file my text is truncated. My 2 coloums have a leading zero 0 followed by 19 or more numbers. I have set the column types to number and text however can not get it to export the actual number.

Example

00093007705112507830 exports to 9.30077E+16

02093101940015493701281022181510012408066774 exports to 2.09310194001549E+42

I have tried to convert to text in the csv file once downloaded however it does not return the correct number.

Any help would be greatly appreciated

WillowMobileSys

The values you are seeing are not truncated. They are in Scientific Notation - a way to take large number and represent them in a condensed form.

Since you have already tried defining the column in AppSheet as Text, then this is probably an issue with how you are viewing the CSV file. If you are looking at it in a sheet, the column may be defined such that the number is formatted into Scientific Notation. Try opening the file in a text viewer OR open a blank sheet, define all the columns as Text and then open the CSV file into that sheet.

dbaum

If you haven't already, try confirming how the data is stored in the first place. Even if the column is Text type in AppSheet, it might be a number in the spreadsheet data source. If so, maybe that's affecting your output. See Solved: Google spreadsheet backend treating a string start... - Google Cloud Community for a screenshot of how to confirm and set the format within a Google sheets data source.

TWE_Toll

Thanks for you help.

I have used your solutions and have it working.