openmolecules.org

 
Home » DataWarrior » Cheminformatics » Show multiple values as... (How the multiple values in the cells should be entered, to use this option.)
Show multiple values as... [message #118] Fri, 06 November 2015 06:50 Go to next message
jeetu270 is currently offline  jeetu270
Messages: 22
Registered: October 2015
Location: INDIA
Junior Member

How to separate the multiple values in a cell to be able to use the "Show multiple values as" option in the column header. Should we use a blank space, comma, semicolon, or : etc?
Re: Show multiple values as... [message #120 is a reply to message #118] Tue, 10 November 2015 16:03 Go to previous messageGo to next message
thomas is currently offline  thomas
Messages: 646
Registered: June 2014
Senior Member
Multiple values need to be separated by either semicolon followed by a space (e.g. '5.2; 3.3; <11.1'),
they may be in multiple lines or it can be a combination of it. To use multiple lines one can either
edit the value directly in DataWarrior or create a textfile with new-line encodings as '<NL>' (without the quotes).

DataWarrior allows a couple of modifiers to precede (<, >, <=, >=) or replace a numerical value (?, NaN).
Columns with numerical values and modifiers are still perceived as numerical data.

Best wishes,

Thomas
Re: Show multiple values as... [message #123 is a reply to message #120] Tue, 08 December 2015 06:39 Go to previous message
jeetu270 is currently offline  jeetu270
Messages: 22
Registered: October 2015
Location: INDIA
Junior Member

Sorry for responding late, but thanks alot for the answer. Its working now...
Previous Topic: can you give an example on how to use refvalue()...
Next Topic: What method is used to cluster compounds
Goto Forum:
  


Current Time: Fri Mar 29 16:09:26 CET 2024

Total time taken to generate the page: 0.06636 seconds