I get reports and load files that, annoyingly give data sizes in the following format:
e.g.,
0.99 GB
1.01 MB
264 KB
I would like the normalize the cell values to bytes. Currently, I do this in Excel with a formula. But since I am getting these reports frequently, I would like to do the normalization within Knime rather than opening and editing the csv files in Excel every time.
Is there a Node that will let me run an Excel formula on a column’s values and have it create a new column with the resulting values?
It looks like the Math Formula node could work, but I would rather use the Excel formula I have than learn to use the Java Math Expression Parser coding.