How to extract part of string after '*', '~', '-' or '#'

Question

I have strings like this:

234/1-1
3345#5
11/2~10
6754*15

It needed only rightmost part of string after '-', '#', '~'or '*' . I figured how to extract when there is only one sign for example '~' with right and strpos. Can I do that with all at once with field calculator?

Answer 1

ArcGIS Method

In field calculator switch the parser to Python and check the "Show Codeblock" box.

In the Pre-Logic Script Code box enter

import re
def splitField(inField):
    return  re.split('[-|#|~|\*]', inField)[1]

In the TEXT box enter

splitField(!nameofField!)

QGIS Method

Open Field Calculator and go to the Function Editor tab.

In the code pane enter

import re
from qgis.core import *
from qgis.gui import *

@qgsfunction(args="auto", group='Custom')
def splitField(inField, feature, parent):
    return  re.split('[-|#|~|\*]', inField)[1]

Click the load button.

Go to the Expression tab and enter

splitField("NAMEOFFIELD")

Set your output field.

Then click OK to run.

Answer 2

Hmm not sure how to do it all at once but you can do it in a couple of steps. I made an example using the values you specified:

---

1. First we need to replace all forward slashes with an underscore _, the reason for this will be explained in the next step. You can use the expression:

   replace( "name", '/', '_')
   

   

---

2. Now we can extract the strings after any non-ASCII symbols such as those you mentioned. We can do this a varierty of operations:

   • substr - returns a part of a string
   • strpos - return first matching position of a substring

   We will also use the special regular expression operation \\W which matches any non-alphanumeric character (i.e. anything other than letters, numbers, ^ and _). This is why we needed to replace / with _. Combining all the above allows us to extract the string after a non-alphanumeric symbol:

   substr( "replace", strpos( "replace", '\\W+')+1, strpos( "replace", '\\W+'))
   

   

We also use +1 because we do not want to include the non-alphanumeric symbol itself, only everything after it.

---

3. Result: