3 Replies Latest reply on Mar 26, 2015 7:59 AM by Felix Curran

    Extracting the word within two backslashes or starts with one backslash

    Tim Molitor

      I need to extract just the word out of the following examples:

       

      /jeans/

      /jeans

       

      I'm able to extract the word when there is a backslash on both sides but need help figuring out how to write it so that if there's only 1 back slash it also returns just the word.

       

      Here's what i'm using to remove the word when there's a backslash on either side of it:

       

      LEFT(

      MID([Website],

      FIND([Website],"/")+1),

      FIND(MID([Website],FIND([Website],"/")+1),"/")-1)

       

      Can anyone help point me in the direction of how to get the word out regardless of whether there is a backslash on both ends of the word or just a backslash at the front?