Split function in Formula Tool or any equivalent - multiply values from text

gregx

Hello,

I have values in text field for example:

"1#2#3.3#-4.9"

I would like to multiply all values separated by #, so in this case it would be 1*2*3.3*(-4.9).

Is there any function that can handle it?

Just to add - Text to Column won't work as the number of items in the text may vary (may be 1, may be 20, there is no rule).

Christina_H

There isn't a simple formula for this, although I think you might be able to use Dynamic Formula from CReW macros.  Here's a way to do it.

It does rely on # being the only symbol included that can't be converted to a number.

Split and multiply.yxmd