1

The strpos() function searches from the left side of the string. But instead of always trimming the string, I would like to get the position from the right side. Is there anyway to do this in the field calculator?

Here is the specific case of application:

enter image description here

I wanted to get the part of the string in "FolderPath" up the first '/' from the right.

2
  • 1
    I think this is a pure Python question about string manipulation that you would be better researching at Stack Overflow.
    – PolyGeo
    Jul 13, 2016 at 8:56
  • Maybe,but I needed to solve it immediately and am not as firm to python as I wanted to be. Without creating a auxiliary field I used: right("FolderPath",length("FolderPath")-29). Since there are always 29 characters infront of my aimed string part.
    – Velester
    Jul 13, 2016 at 9:01

1 Answer 1

2

I would use regexp_substr instead of strpos so in your example something like:

regexp_substr("FolderPath",'.*/') 

The first item ("FolderPath") is your column name (enclosed in "), the second is a standard python regular expression. There is a regexp howto available to help you out.

1
  • I'm playing around with your suggestion, but it doesnt work. ofc i used"regexp_substr()". Do you have a good documentation what to write in the 'regex'?
    – Velester
    Jul 13, 2016 at 9:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.