Hi There!
I have a column with Latitude and a column with Longitude and I want to transform in Coordinates.
The problem is that the columns are in this format:
23° 12' 51" S | 51° 11' 9" W |
Any help?
Best
Hi There!
I have a column with Latitude and a column with Longitude and I want to transform in Coordinates.
The problem is that the columns are in this format:
23° 12' 51" S | 51° 11' 9" W |
Any help?
Best
Hi Fabio,
the Regex Split node does all the magic for you. With the regular expression (\d+).* (\d+).* (\d+).* (\D) you get hours, minutes, seconds and cardinal direction in seperated columns. Afterwards you perform a Column Auto Type Cast to transform the resulting strings to integers, compute the coordinates and negate them with the Rule Engine and another Math Formula node where it is neccessary.
I attached an example-workflow for illustration purposes. Hope that helps.
Cheers
Marten