openmolecules.org Forum - RDF feed
type: channel
description: Forum about DataWarrior and other openmolecules.org related issues
items: Opening a .csv file
items: Re: Opening a .csv file

Opening a .csv file
type: item
description: I am trying to open .csv files, but each time the data appears in one single column instead of being splitted in multiple columns. I have seen online that the right way to do it is "Open Special" ==> "Text file", but I cannot seem to fine this option... Datawarrior version : 5.5.0 Could anyone guide me please ?
creator: gdeutsch
date: 2022-03-04T09:41:25-00:00

Re: Opening a .csv file
type: item
description: 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
creator: nbehrnd
date: 2022-03-05T17:26:31-00:00

Re: Opening a .csv file
type: item
description: Thank you very much for your help ! It is hugely appreciated !
creator: gdeutsch
date: 2022-03-07T14:42:03-00:00