Splitting field with comma as separator into two fields in QGIS

Question

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.

Please see the similar question http://gis.stackexchange.com/questions/32996/trimming-specific-text-values-in-qgis-field-calculator since the process to split into new fields will be similar. — , Jun 12 '13 at 13:55
This topic How to split a text attribute by characters in QGIS 2.6.0 looks similar to me as well. — Taras, Feb 12 '19 at 08:14
And this one as well How to extract a part of string from fields in QGIS field calculator? — Taras, Feb 12 '19 at 08:20

score 4 · Answer 1 · answered Jun 12 '13 at 15:53

4

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))

answered Jun 12 '13 at 15:53

MappaGnosis

33,857
2
66
129

In both cases, comma remains in a new substring. I assume it should include "-1", i.e. left("myField", strpos("myField", ',')-1) for "myField" values like 'My Street, 1A'. – Taras Feb 12 '19 at 08:10

score 2 · Answer 2 · edited Apr 14 '20 at 12:52

2

My solution: array_to_string(array_slice(string_to_array( "string.Split.By.Dot",'.'),1,3),'.') => "string.by.dot" Where 1,3 is index of the start and end of slice.

edited Apr 14 '20 at 12:52

MrXsquared

34,292
21
67
117

answered Apr 14 '20 at 12:16

kivi_or

21
2

Splitting field with comma as separator into two fields in QGIS

2 Answers2

Linked