Home » DataWarrior » Functionality » Calculations on multiple values gives one value?!
Calculations on multiple values gives one value?! [message #461] Fri, 01 February 2019 11:49 Go to next message
Dennis is currently offline  Dennis
Messages: 4
Registered: May 2018
Location: Netherlands
Junior Member
Is there a way to do calculations on multiple values in one cell and get the same amount of values in another cell.

For example:

In one cell (column2) I have 10 and 100 separated by ;
If I add a calculated value (log(Column2)Wink, I get 1.74...
Instead of 1.74, can I get 1;2?
Re: Calculations on multiple values gives one value?! [message #468 is a reply to message #461] Tue, 12 February 2019 19:00 Go to previous message
thomas is currently offline  thomas
Messages: 247
Registered: June 2014
Senior Member
no, currently, there is no way. It might also be difficult to implement that in a consistent way, because one formula may refer to more than one cell, e.g. "log(column1)+column2". If these cells had different value counts, then it would be unclear how to handle the matter. A second reason is that the "Java Expression Parser", the calculation engine that resolves the formula, does not know about a DataWarrior table and cell content. It just expects a variable to be resolved into one value.
Previous Topic: Viewing 3-D structures from an imported SDF in DW.
Next Topic: Loss of stereochemical information when importing sdf file
Goto Forum:

Current Time: Fri Dec 13 01:11:51 CET 2019

Total time taken to generate the page: 0.00293 seconds