How can I convert a field with data size with unit to normalize to bytes

KNIME Analytics Platform
1

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.

2

Hello @mnblockhead,

I believe you may be looking for this node:

It returns the result of the excel formula.

Hope this helps,
TL

2 Likes