if condition

[capriconuser]

there is data in column like 

56.98 MB

45.67 GB

i want if data has MB then want to multiply by 0.1 if not then same value will load which is in data ..

how I do that in script 

[PradeepK]

Can you provide more info.. 

seems like column is of type $text; What exactly are you expecting.. when you say multiply by 0 to a $text field ?

Anyways, look into Right() and WildMatch() script functions.

Also just a tip; Keep data type i.e. MB, GB info into separate field.