cancel
Showing results for 
Search instead for 
Did you mean: 

CSV Format Issue

maneesh.vemula1
Level 5
Hi - I have a file that is coming through in a CSV format. The file contains numbers that exceed 15 characters. ex: 43283423423428. This number when saved in a CSV format is being converted to "43283423423420". The ending 8 is replaced with 0. However, while opening with a notepad - the number seems to be correct. Is there workaround or a way to format the data in the CSV so that the last digit won't be a different number. Please let me know. Thanks in advance.

------------------------------
Maneesh Vemula

------------------------------
7 REPLIES 7

VivekGoel
Level 10
How is that even possible. I haven't seen such issues for a whole number, with fractions, I can stil understand the issue.

How are you opening  the file where you are seeing the issue ? "43283423423420" , is it in Excel?..Can you share some screenshots to provide steps to reproduce the issue?

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
https://www.rpatools.com/
"If you like this post, please press the "Recommend" Button.
------------------------------

Hi - Please see image, As you will see the csv file when opened in notepad displays the entire number correctly. But when opened in excel - the last digit is converted to 0. I am using MS Excel VBO (create instance, open, get worksheet as collection(fast)) to retrieve the data. Please let me know if you need any other information. Thanks in advance!

------------------------------
Maneesh Vemula
RPA Specialist
America/New_York
------------------------------

Try using read csv option directly.



Sent from my Samsung Galaxy smartphone.


------Original Message------

Hi - Please see image, As you will see the csv file when opened in notepad displays the entire number correctly. But when opened in excel - the last digit is converted to 0. I am using MS Excel VBO (create instance, open, get worksheet as collection(fast)) to retrieve the data. Please let me know if you need any other information. Thanks in advance!

------------------------------
Maneesh Vemula
RPA Specialist
America/New_York
------------------------------

The result is still the same - number ending with a 0.

------------------------------
Maneesh Vemula
RPA Specialist
America/New_York
------------------------------

Hi Maneesh,

Please try the below solution and let me know.

https://community.blueprism.com/communities/community-home/digestviewer/viewthread?MessageKey=050166b9-505d-48cc-970d-5e81be6a4b17&CommunityKey=fa047dc0-20a4-4608-af34-ae6578160b33&tab=digestviewer#bm...

------------------------------
Naga
Associate
Asia/Kolkata
------------------------------

Hi Naga - I am unable to open the link. Can you please provide the solution here.? Thank You.

------------------------------
Maneesh Vemula
RPA Specialist
America/New_York
------------------------------

TomCirone
Level 6
This is a documented behaviour in excel

https://www.excelforum.com/excel-programming-vba-macros/704640-csv-number-rounding.html
https://superuser.com/questions/925587/how-to-prevent-excel-to-round-a-number-at-opening

------------------------------
Tom Cirone
Application Developer
Essity
America/New_York
------------------------------