Transforming Lat Long in Coordinate

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?


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.