search

thsa / datawarrior

Interactive data analysis and visualisation with chemical intelligence
GNU General Public License v3.0
86 stars 18 forks source link

Type conversion #27

Open Questi1728 opened 4 weeks ago

Questi1728 commented 4 weeks ago

Is there a way to convert string to to numericals? E.g. having a column of 01, 02, 03, .... as a result of a substring() calculation, DW correctly states perceived data type: numerical when hovering over the column header. However, any calculation applied to the numbers will fail. There doesn't seem to be a type conversion, int(x) only accepts double, not strings?

thsa commented 4 weeks ago

I cannot reproduce the issue using the table below. I tried "Add Calculated Values..." with 'int(Num)' and 'Num+2'. Both deliver the expected result. Can you provide an example that fails?

Type Num a 01 b 02 c 03