openmolecules.org

 
Home » DataWarrior » Functionality » Opening a .csv file (Troubles to open .csv file)
Re: Opening a .csv file [message #1529 is a reply to message #1525] Sat, 05 March 2022 18:26 Go to previous messageGo to previous message
nbehrnd is currently offline  nbehrnd
Messages: 224
Registered: June 2019
Senior Member
DataWarrior anticipates the columns in a .csv to be separated by a comma. Other characters occasionally seen in .csv as a separator (e.g., explicit space(s), semi-colon) indeed yield columns to coalesce into one when reading the input file with either File -> Open, or the shorthand Ctrl + O.

Check if the program generating the .csv allows an export with columns separated by a comma while representing floating numbers with a decimal point.

If this isn't adjustable, identify in your text editor of choice (it needn't be a word processor) a «find and replace» function to perform an adjustment in the intermediate form of the .csv before it is read by DataWarrior. In case real numbers originally are represented with a comma, substitute these by a period/full stop in first place; and then substitute our column separator by a comma.

Note, this form of data input converts the first line of the .csv as header of DataWarrior's spread sheet.

Norwid

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Previous Topic: Became enamine database a sub-set of chemspace?
Next Topic: Functionality request: MPO score
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Fri Nov 22 11:33:09 CET 2024

Total time taken to generate the page: 0.03966 seconds
openmolecules.org