4 Replies Latest reply on Aug 19, 2016 12:22 PM by Jennifer Martine

    REGEXP for alphanumeric then using formula for conversion.

    Jennifer Martine

      Can anyone assist with creating a calculated field using regexp for an alphanumeric excel field that also needs to be converted to Miles if it is currently in Kilometers?

      I've tried isolating the numbers first. Then isolating the letters. Then an IF/THEN calculation stating if M, then leave as is, but if K multiply .621. All my calculations are valid, yet now I have 4 separate calculated fields and the final one is all Null.

       

      Anyone have another solution that using only one calculated field?

       

      The excel cells look like:

      96821 K

      461894 K

      1200 M

      2631 K