openmolecules.org Forum: Bug Reports » Issues with reading CSV-files

Home » DataWarrior » Bug Reports » Issues with reading CSV-files

Show: Today's Messages :: Polls :: Message Navigator

Issues with reading CSV-files [message #569]

Mon, 27 May 2019 10:54

Jan-Mathis
Messages: 2
Registered: May 2019

Junior Member

I downloaded a CSV-file from the ChEMBL website (see attachments). If I open it, DataWarrior falsely recognizes SMILES in the "ChEMBL ID" and "Type" column. Also the header is erroneous. For example it displays the title "Type" as "T_y_p_e".
I already downloaded the bugfix you posted on another thread on the 17.1.2019.

Attachment: CHEMBL25-chembl_molecule-OjTXHbpRrTByJ-WgMV3ZWCbpTFbxBUjcW19lyiZQMiM=.csv
(Size: 339.96KB, Downloaded 629 times)

Report message to a moderator

Re: Issues with reading CSV-files [message #570 is a reply to message #569]

Tue, 28 May 2019 10:48

thomas
Messages: 728
Registered: June 2014

Senior Member

DataWarrior expects UTF-8 encoded text files. Your file is UTF-16 encoded. You may convert the file with many text editors, e.g. use "Text Editor" in Ubuntu to open the file. Then choose 'Save As', choose character encoding 'UTF-8' and press OK. I have attached the converted file, which opens nicely in DataWarrior.

Attachment: chembl25_problem_UTF8.csv
(Size: 169.98KB, Downloaded 550 times)

[Updated on: Fri, 31 May 2019 11:55]

Report message to a moderator

Re: Issues with reading CSV-files [message #572 is a reply to message #570]

Tue, 28 May 2019 21:13

Jan-Mathis
Messages: 2
Registered: May 2019

Junior Member

Thanks for the quick answer. Now everything is working.

Report message to a moderator

Previous Topic:	Uncaught Exception
Next Topic:	Index Column too small for large numbers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Apr 04 10:55:11 CEST 2025

Total time taken to generate the page: 0.04492 seconds