openmolecules.org Forum: Cheminformatics » Show multiple values as...

Home » DataWarrior » Cheminformatics » Show multiple values as... (How the multiple values in the cells should be entered, to use this option.)

Show: Today's Messages :: Polls :: Message Navigator

Show multiple values as... [message #118]

Fri, 06 November 2015 06:50

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?

Report message to a moderator

Re: Show multiple values as... [message #120 is a reply to message #118]

Tue, 10 November 2015 16:03

thomas
Messages: 728
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

Report message to a moderator

Re: Show multiple values as... [message #123 is a reply to message #120]

Tue, 08 December 2015 06:39

jeetu270
Messages: 22
Registered: October 2015
Location: INDIA

Junior Member

Sorry for responding late, but thanks alot for the answer. Its working now...

Report message to a moderator

Previous Topic:	can you give an example on how to use refvalue()...
Next Topic:	What method is used to cluster compounds

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Apr 03 04:56:32 CEST 2025

Total time taken to generate the page: 0.03643 seconds