I have a field that has a sometimes long and varied string - folder names in systems essentially.
I need to extract the last portion of the strings which happens to occur after the third instance of a forward slash ( / ).
Is there an easy method to count to the Nth instance of a character and then either trim everything before that, or keep everything after that - whichever way you want to think about it?
