openmolecules.org

 
Home » DataWarrior » Bug Reports » Issues with reading CSV-files
Issues with reading CSV-files [message #569] Mon, 27 May 2019 10:54 Go to next message
Jan-Mathis is currently offline  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.
Re: Issues with reading CSV-files [message #570 is a reply to message #569] Tue, 28 May 2019 10:48 Go to previous messageGo to next message
thomas is currently offline  thomas
Messages: 646
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.

[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 Go to previous message
Jan-Mathis is currently offline  Jan-Mathis
Messages: 2
Registered: May 2019
Junior Member
Thanks for the quick answer. Now everything is working.
Previous Topic: Uncaught Exception
Next Topic: Index Column too small for large numbers
Goto Forum:
  


Current Time: Fri Mar 29 10:07:11 CET 2024

Total time taken to generate the page: 0.07399 seconds