Hi,
I am dealing with location coordinates, arranged in same column. I need to obtain two columns (latitude and longitude), but I am facing difficulties to find a way to split the column. Actually, I thought on splitting the column content based on two delimiters: + -
Is it possible? Is there a better solution:
Location (Current column content)
+49.2446-123.064/
+49.24966-123.11934/
+40+155/
+13.58283+144.83534/
After splitting:
Latitude Longitude
+49.2446 -123.064/
+49.24966 -123.11934/
+40 +155/
+13.58283 +144.83534/
Many thanks,
Cadu