Hello JMP Community,
I got this dataset of electrical vehicle data from data.gov. It has a column where it gives geo location but the column entries are in the given format:
POINT ( Longitude, Latitude)
for example one row is
POINT (-122.34301 47.659185)
and I want to create two new continuous columns for Longitude and Latitude
My problem is that when I try to extract the string of numbers using the LEFT(), RIGHT(), or SUBSTR() function, the results are inconsistent because the string of numbers is not always the same.
Such as
POINT (-122.6880708 48.2179983) & POINT (-121.9725 47.85674)
what would be the best way to make these latitude and longitude columns?
I've attached the JMP Data set.
thank you,
-lovy
