topic RE: CSV Format Issue in Product Forum

CSV Format Issue

maneesh.vemula1 — Thu, 19 Dec 2019 21:33:00 GMT

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

------------------------------

RE: CSV Format Issue

vivek.kumar.goel — Fri, 20 Dec 2019 03:51:00 GMT

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

RE: CSV Format Issue

maneesh.vemula1 — Fri, 20 Dec 2019 17:26:00 GMT

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

RE: CSV Format Issue

vivek.kumar.goel — Fri, 20 Dec 2019 17:39:00 GMT

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

RE: CSV Format Issue

maneesh.vemula1 — Fri, 20 Dec 2019 18:46:00 GMT

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

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

RE: CSV Format Issue

NagaM — Mon, 23 Dec 2019 03:57:00 GMT

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#bm050166b9-505d-48cc-970d-5e81be6a4b17

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

RE: CSV Format Issue

maneesh.vemula1 — Thu, 06 Feb 2020 20:02:00 GMT

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

RE: CSV Format Issue

TomCirone — Fri, 06 Mar 2020 15:55:00 GMT

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