How to split a "Field" into "Field 1" and "Field 2" when the comma is a separator in the field?
I am using Field Calculator in QGIS.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
If you want to use the field calculator, it is quite straightforward. To get everything to the left of your comma use the following expression:
left("myField", strpos("myField", ','))
To get everything to the right of the comma use this expression:
right("myField", length("myField")-(strpos("myField", ',')+1))