Forum about DataWarrior and other openmolecules.org related issues
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 ?
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
Thank you very much for your help ! It is hugely appreciated !