Contents x
      QQ - How do I transform data loaded as string into a double?
      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Contents

      QQ - How do I transform data loaded as string into a double?

      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Article summary

      Lat/long data loaded in format

      N 51.987878 

      E 00.654987

      How do we transform this into usable Numeric fields?

      1. Use expression mid to trim the data and remove leading letters
      2. Use a programmed field to convert the data to a double   or
      3. Use String | DCAST


      Was this article helpful?
      What's Next