After running the “Locations of power stations” query, one of the resulting columns is a string column
with coordinates encoded as “Point(25.19 43.63)”. Is there a way to convert that column to two numerical columns ‘latitude’ and ‘longitude’?
This is easy. Click on Data | Split Column… , enter “( )” in the “Split by” field, and check “By chars” option. This will produce three columns - the first one containing “Point”, followed by two numerical columns with latitude and longitude. By the way, after you click OK, you can grab the generated macros from the Console. You can execute it by pasting it into the Console (the same concept applies to most commands).
SplitColumn("Locations of power stations", "coord", "( )", "col", false, true)