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.
-
1Please see the similar question gis.stackexchange.com/questions/32996/… since the process to split into new fields will be similar.– user3461Jun 12, 2013 at 13:55
-
This topic How to split a text attribute by characters in QGIS 2.6.0 looks similar to me as well.– TarasFeb 12, 2019 at 8:14
-
And this one as well How to extract a part of string from fields in QGIS field calculator?– TarasFeb 12, 2019 at 8:20
Add a comment
|
2 Answers
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, 2013 at 15:53
-
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'.– TarasFeb 12, 2019 at 8:10
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.
