9 Replies Latest reply: Jan 2, 2014 4:34 AM by Ralf Becher RSS

    String handling of file Path

    Boris Kacevich

      Hi all,

       

      This is part of my script:

       

      for each FoundFile in filelist( Root & '\*.csv') 

              let vTemp=  '$(FoundFile)';

              let vTemp2= upper(left(filename('$(FoundFile)'),len(filename('$(FoundFile)'))-21));

       

      The result is:

      vTemp"C:\decisioning\log\dcs\1\1\dcs_meta_data_20131126113434.csv"
      vTemp2<NULL>

       

      I'm trying to isolate the file name without the date stamp, extension and folders and to show it in upper case letters.

       

      where am I wrong?

       

      Thanks,

       

      Boris