Contact Us Now

Q: Move a file and send email with filename and line count.

Can you help me with the following question.

I want to move a file and in an email state the file name (always a text file .csv, .txt) and a line count
Test.txt – 12 lines

Can this be done?

A: Yes this is possible. We have created a Pascal Script for you to achieve this.

1. It is important that you’ll only handle txt and csv files (text based files). We added a File Name Include File Filter, just to be sure:

2. Open our ‘Pascal Script’ option:

Add and enable the following ‘On Destination’ Pascal Script. This script will load the txt/csv file and will put the line count information into our %VSA parameter which can be use within our notification email.

Var
  tmpCount: Integer;
  tmpList: TStringList;
Begin
  psExitCode:= 0;
  // ... add your code here
  tmpList := TStringList.Create;
  Try
    Try
      // Load Source File
      tmpList.LoadFromFile(psFilePath + psFileName);
      // Count Lines
      tmpCount := tmpList.Count;
      // Info to be used in email
      psVSA := psFileName + ' - ' + IntToStr(tmpCount) + ' lines';
      psLogWrite(1, '', 'Information: ' + psVSA);    
      // Set Result OK
      psExitCode := 1;
    Except
      psLogWrite(1, '', 'Error loading: ' + psFilePath + psFileName);
    End;
  Finally
    tmpList.Free;
  End;  
End.

3. Now you can use the %VSA as parameter within the email setup:

4. Email Result:

#Filetransfer

If you need any info about this option, please let us know.

Best regards,

Limagito Team