Change part of script

[DinaH]

Hi

I have data that I load from an excel file.  One of the columns in the data is a unit of measure column.  The unit of measure for example can be EA or P10.  In this cases I would like to have in my script a "formula" to convert the EA to a "1" and the P10 to the "10" only

How can I do this?

Thank you

[stevejoyce]

Your load script formula can be:  Pick(Match([unit of measure column], 'EA', 'P10'), 1, 10)

You can use that to multiply by your measurement column.