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

  • 1 minute(s) read
Prev Next

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