9 Replies Latest reply: Mar 18, 2014 9:53 AM by snehal mejari RSS

    data in one format

    snehal mejari

      i have data in different format for field1

      for ex:-1mb,2MB,3MBPS,34 kb,98KBPS,6gb,etc

       

      but i want it one format i.e in MBPS  i need to convert kb to mb and gb to mb

       

      and mbps =mb same for kbps=kb

       

      Please suggest