3 Replies Latest reply: Aug 31, 2015 11:05 AM by janith harsith RSS

    Text between from the right side

    Nemanja Momic

      Hello all,

       

      as you can read in the title, how can I to the text between function from the right side?

       

      Example:

       

      c:\\Folder\Sub\Sub2\File1.txt

       

      c:\\Folder\Sub\Sub3\Sub7\File2.txt

       

      c:\\Folder\Sub\Sub2\File3.txt

       

      I need to get a column with values like this:

       

      Table:

      File1,

      File2,

      File3.

       

      Is there a way to do this?

       

      Thanks in advance