Removing text after character or between characters

I had a similar requirement to select text after the last "/(slash)" (example: /BR/1Dev/TextOfInterest and I needed to extract only the text after the last "/" Result: TextOfInterest). The method I used to do this is:

1. Select the column you are interested in and go to "Transform"

2. and click on "Extract" which is 1 of the options in "text column",

3. then choose "text after delimiter" (because I wanted text after the last "/")

4. Fill in the type of delimiter you have in your text (in my example it's / ), specify if you want to scan the text from start or end and number of delimiters to skip (in my example it is 0), then click OK and that's how I transformed the column of interest to get only the text after the last /.

Hope this helps.

Thanks