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,