3 Replies Latest reply: Jan 2, 2014 6:02 AM by Clever Anjos RSS

    Extract sub folder name from a full file path

    Boris Kacevich

      Hi,

       

      This is an example for a path that I have:

       

      C:\decisioning\log\dcs\1\1\dcs_meta_data_20131126113434.csv


      I need to compare the folder number highlighted in RED to a list.


      how can I isolate the folder number?

      I had a code written with FileName function but I know it doesn't work in regular script but only in load script.



      regards,


      Boris