[GIS] Splitting string (the last digits) in QGIS

field-calculatorqgissplittingstring

I´m working with QGIS 2.12. Is it possible to split string "from the right side" (it means I needed the last text from every field)?

In one field I have description like:

description
new street 25
old street 2
lower 26A
lower new street 125
Jozefs and Elisabeths new gardens 147A

Every line has a different count of texts. I needed a column with numbers:

Could be possible in QGIS?

You can do it using the following formula in the Field Calculator:

regexp_substr("Field_Name",'(\\d+|\\d+.+)')

Where:

The first \ is to escape \d

\d+ : means extract one or more digits.

| : means OR.

\d+.+ : means extract one or more digits and one or more any other character.

It will give you the following results:

Even if you have text with a name 'Text 123456789ABCDEF', the output will be:

123456789ABCDEF

You can use substr.

So:

substr(  "Field" , 13,  length( "Field"))

So this grabs everything from the 13th to the Nth character, with the Nth being the lenght of the field.

To remove the numbers at the beginning of the string and its optional following space, you can use

regexp_replace(address,'^\\d*\\s?','')

^: beginning of the string
\\d: followed by any digit
*: found 0 or more time
\\s: followed by a space
?: found 0 or 1 time