This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

CSV Export Text Truncated

Posted on 07-10-2022 03:28 PM
TWE_Toll
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

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

 

 

 

0 3 630
Topic Labels
0 Likes
3 REPLIES 3
Top Labels in this Space