Forum Discussion

wynandb1's avatar
wynandb1
Contributor
10 years ago

Verify value in text file

Good day    I need to verify a specific value in a text file. It's a date value in YY/MM/DD format. It's in line 3 and starts at column 59 and ends at column 64.   From what I can see in the tuto...
  • cunderw's avatar
    cunderw
    10 years ago

     

    function ReadDateFromFile(){
  var sPath = "PATHTOFILE";
  
  // Opens the specified file for reading
  var myFile = aqFile.OpenTextFile(sPath, aqFile.faRead, aqFile.ctANSI);
  
      // Skips to the specifed position and reads the specified amount of symbols
      myFile.SkipLine(NUMBEROFLINES);
  myFile.Skip(NUMBEROFCHARACTERS);
  var sDate = myFile.ReadString(10);
    
  // Closes the file
  myFile.Close();
}

    The above script should work to get just the date from the file, then you can set it to a variable and compare it like any other variable.

     

  • HKosova's avatar
    HKosova
    10 years ago

    Or use aqFileSystem.FindFiles to find a file by mask:

     

    var foundFiles = aqFileSystem.FindFiles("C:\\FolderName\\", "FileName_*_*");
if (foundFiles != null) {
  if (foundFiles.Count == 1) {
    var sPath = foundFiles.Next().Path;
        Log.Message(sPath);

        // Read data from the file
        // ...
      }
  else {
    Log.Error("More that 1 file found.");
  }
}
else {
  Log.Error("File not found.");
}

     

cunderw's avatar
cunderw
Community Hero

Ok, so how is it generated?

 

You can do the same thing with that part as well and generate it programatically then concantenate it to the filepath string.

HKosova's avatar
HKosova
SmartBear Alumni (Retired)
10 years ago

Or use aqFileSystem.FindFiles to find a file by mask:

 

var foundFiles = aqFileSystem.FindFiles("C:\\FolderName\\", "FileName_*_*");
if (foundFiles != null) {
  if (foundFiles.Count == 1) {
    var sPath = foundFiles.Next().Path;
    Log.Message(sPath);

    // Read data from the file
    // ...
  }
  else {
    Log.Error("More that 1 file found.");
  }
}
else {
  Log.Error("File not found.");
}

 

  • wynandb1's avatar
    wynandb1
    Contributor
    10 years ago

    Thank you for the reply's

     

    I have tried to merge your scripts together and execute it in TC , but the execute button is read only, So can you please combine the scripts for me  ?

    • Marsha_R's avatar
      Marsha_R
      Moderator
      10 years ago

      sub mytest()

       

      *put all the other script stuff here*

       

      end sub

      • wynandb1's avatar
        wynandb1
        Contributor
        10 years ago

        Ok .. 

         

        This is what I tried, but I get the following error when I execute the script.  JScrip Compilation Error. Expected ";" Line1 Column 5

         

         

        sub mytest()


        function ReadDateFromFile(){
        var sPath = "PATHTOFILE";

        var sPath, currentDate, sCurrentDate;

        currentDate = aqDateTime.Today();
        sCurrentDate = aqConvert.DateTimeToFormatStr(currentDate,"%m%d%Y");
        sPath = "C:\\Outgoing\\SUREBANK_EFT_OUT" + sCurrentDate + "_12345";

        // Opens the specified file for reading
        var myFile = aqFile.OpenTextFile(sPath, aqFile.faRead, aqFile.ctANSI);

        // Skips to the specifed position and reads the specified amount of symbols
        myFile.SkipLine(NUMBEROFLINES);
        myFile.Skip(NUMBEROFCHARACTERS);
        var sDate = myFile.ReadString(10);

        // Closes the file
        myFile.Close();
        }

        end sub