I have a combined latitude and longitude field, separated by a semicolon. The halves are not fixed length.
How can I extract latitude and longitude from this combined lat-long location text?