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

    data in one format

      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