I'm a GIS novice. I have a CSV file that contains the latitude and longitude data for a small region in the northeast U.S. The data appear in one column appearing as one uninterrupted string of text in each field. I need to separate this data into two columns.
Each field is formatted like this, with all fields in this column having the same number of digits:
Two other issues: each field begins with "xy," and the longitude (or "y") should have a minus sign in front of it because the location for this map is within the western hemisphere.
How can I separate this column into two columns so that 1) the "xy" disappears and 2) the longitude includes a minus sign? OR will QGIS3 be able to automatically read and correctly interpret this column because of placement of "xy" before each number?
I've searched answers to this "one-column to two-column" issue, but all the questions referred to lat-long figures separated by a comma in their respective fields. There were some references to use of the field calculator - but I don't know how to use that, either.