Table parses CSV incorrectly

[moookie]

Hi In my CSV File I have a long numeric value

I.E. 0085003900167367 when I retrieve this value from the file with the Table function it gets transformed to something completely different like : 0.8500390016739E which makes is unusable for me.

Any way to avoid this ? I assume this has to to do that the table function does not handle this column/cell as a TEXT value.

 

[VladZen]

That's how data from your CSV file were converted to UTF-8 encoding. To avoid the problem you should change content encoding in your CSV file to UTF-8.

 

[moookie]

The file is a CSV file in UTF8 ... Still experience the problem though

 

[VladZen]

The file is a CSV file in UTF8 ... Still experience the problem though

Please attach such sample CSV file, so that we could reproduce the problem.

 

[moookie]

I was unable to upload a CSV file, but if you create one with the following content and load it in a list you will see it in action:

John,12100331207988172284

What is the best way to solve this issue ?

 

[VladZen]

I was unable to upload a CSV file, but if you create one with the following content and load it in a list you will see it in action:
John,12100331207988172284

Sorry, no problems with it.

 

[VladZen]

What ZP version do you have?

 

[moookie]

The latest pro version. Please note that the separator for the file is a comma ( , ) . If you load it like that it will occur

 

[VladZen]

Please note that the separator for the file is a comma ( , ) . If you load it like that it will occur

Ok, got it. We will investigate the issue.

 

[Nick]

In Excel you can put a single quote sign like this: ' - before the number. Then it won't be normalized. Try it in a file, it could help.

 

[VladZen]

The latest pro version. Please note that the separator for the file is a comma ( , ) . If you load it like that it will occur

Exel works the same if you set comma as separator. It is not ZennoPoster issue. Try workaround suggested above by Nick.