I have a string with a bunch of latitude and longitudes like this
LINESTRING (-79.0578544444577 43.0929133770364, -79.0559554404751 43.0929995585932, -79.0540564364926 43.09308574015, -79.0504086322323 43.0931797561892, -79.0503228015438 43.0911427096913)
and I want to get the coordinates out of the string into an array. I know this can be done with string splitting but I dont understand how to write the expression to get just the coordinates from the string.
can someone help me outwith this