DSXchange

Hi

I have a requirement where if the description is "abc /1 ml" or "abc/ml" or "abc/1ml @ 10 min" then I need to multiply the other column i.e the value to 100.

Please suggets. Is it possible in transformer??

Regards,
Arnie.

Check Index()

From your description (exact text for description) I'd suggest a simple If..Then..Else construct would suffice.