1 2 Previous Next 27 Replies Latest reply on Jul 24, 2014 9:13 AM by sandrine lhuissier

    Convert calculated field into float

    sandrine lhuissier

      Hi,

       

      I ve create a calculted field with this formula:

      Longitude = (TRIM(LEFT([geo_coordinates],FIND([geo_coordinates],",")-1)))

       

      geo_coordinates is a String like "48.884079, 2.37615"

      i 'd like to obtain 2 float number:

      Longitude = 48.884079

      and

      Lattitude = 2.37615

       

      But i cant' convert the calcultated string field into a float number

       

      Anyone?

       

      Thnaks

        1 2 Previous Next