3 Replies Latest reply on Jun 27, 2013 8:32 AM by Allan Walker

    Left and Right with Find

    Allan Walker

      Hi, I have a field name [geo_coordinates]

       

      I wish to create two CF's - one called latitude and the other longitude

       

      Here is the standard output with an example:

       

      loc: -23.02860309,-45.56177326

       

      So, I want to strip (trim? replace?) "loc: " and then find ","

       

      Everything Left of "," would be [latitude] and everything right of "," would be [longitude]

       

      I'm almost there with LEFT([geo_coordinates],FIND([geo_coordinates],",")-1) for latitude... but it returns loc: -23.02860309.


      Best Regards,

       

      Allan