AnsweredAssumed Answered

Extracting a letter from a text field

Question asked by DavidEnns on Dec 31, 2011
Latest reply on Aug 2, 2015 by Shrab

Title

Extracting a letter from a text field

Post

I have a field containing GPS coordinates: start::Location=N49 30 18.0 W120 40 51.1

 "49" = LeftWords ( Right ( trails::location_Start ; Length ( trails::location_Start ) - 1 ) ; 1 )

"120" = ?

 

1 Is there a way to extract each coordinate (degrees, min,sec) value, minus the letters, store in a temporary field, without having to use a table?

2 What is the formula to extract W120 without the letter?

3 I would be open to more efficient ways of doing this.

 

The field containing gps coordinates is a text field and the format is N## ## ##.# W### ## ##.# 

Outcomes