Obtaining specific part of string from field in QGIS attribute table?

Question

I'm having a bit of trouble here with this situation.

I want "NumeroCamp" only to have the numbers are showing in "Text".

Is there any function in field calculator that could help me with that?

See this question here: gis.stackexchange.com/questions/127415/… — MaryBeth
– MaryBeth, Commented Feb 13, 2017 at 13:22
I want to create a new field in my attribute table by returning all digits between the / and _ characters of the field named "location" by aplying the expression given by @ArMoraer to my situation: regexp_substr( "Text", '/(\\d*)\_' ) However, it does not give the desired result: ![enter image description here](i.sstatic.net/92zAd.png) How could I adapt the expression to my case? Many hanks in advance to anyone who can help or give any suggestions. — abrobia
– abrobia, Commented Sep 4, 2018 at 17:26
If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review — Bera
– Bera, Commented Sep 4, 2018 at 18:29
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review — Vince
– Vince, Commented Sep 4, 2018 at 20:18

ArMoraer · Accepted Answer · 2017-02-13 13:39:42Z

19

You can use the following expression in the field calculator (tested on QGIS 2.18):

regexp_substr( "Text", ';(\\d*)\}' )

This will return all digits (as text) between the ; and } characters.

answered Feb 13, 2017 at 13:39

ArMoraer

5,7493 gold badges27 silver badges52 bronze badges

MrXsquared · Accepted Answer · 2021-09-23 15:18:09Z

1

string_to_array("text",';')[1]

MrXsquared

36.2k22 gold badges78 silver badges128 bronze badges

answered Sep 23, 2021 at 15:07

LM10

4462 silver badges7 bronze badges

2 Answers 2