please, I need help in scripting for instant JChem for a calculated field. I have next task: exists the field "CAT" with data which coded by letters (as example a, f, g,) , need to fill other data field "LOGK" in dependence of data in field CAT, as examle:
if CAT(i) = "a" then LOGK(i) = 456 \\ if in row "i" field CAT contain "a" then into field LOGK write "456"
else if CAT(i) = "f" then LOGK(i) = 587
else if CAT(i) = "g" then LOGK(i) = 678
else LOGK(i) = ###
table after script