Pascal Script Archives - Page 6 of 30 - File transfer tool from Limagito

19 Feb
How to copy a csv file when a specific row exists
How to copy a csv file when a specific row exists
Q: My client is looking for advanced file copy functionality and have set of requirements for this process. Appreciate if you can clarify below requirements applicability with Limagito. The file copying should not copy the currently modified csv files. Basically, the only difference in the files that are completed and in “modify” mode is a last row in the file – If this specific row not exists, file still in “modify” mode.
A: Yes this is possible. We added two examples (scripts) on how to achieve this.
1. Example 1: will read the csv file and check all rows for a certain keyword
2. Example 2: will read the csv file and will only check the last row for a certain keyword
We used a windows folder as source:
Open our ‘Pascal Script’ option:
Example Script 1 will read the csv file and check all rows for a certain keyword ( RT_Count )
Please enable and add the following ‘On Destination’ Pascal Script: link
You can adjust the Keyword but always in Uppercase
Example Script 2 will read the csv file and will only check the last row for a certain keyword ( RT_Count )
Please enable and add the following ‘On Destination’ Pascal Script: link
You can adjust the Keyword but always in Uppercase
As Destination we also used a windows folder:
RunTime Log Result:
If you need any help with this ‘copy files in a specific order’ request, please let us know.
Best Regards,
Limagito Team
#csv #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Pascal Script XLS/CSV row exists, specific row
09 Jan
How to search for a string and replace it with a CRLF
How to search for a string and replace it with a CRLF
Q: Is it possible to search for a string and replace it with a CRLF (as we say in windows) [Return]
The main issue is to replace <br/> with a carriage return Line feed
A: Yes this is possible by adding the following script:
We used a Windows folder as Source:
Because we only want to process text files, we added the following include filename filter:
As Destination we added our Pascal Script option, do not forget to adjust the ctOutputPath const:
Please add the following script: link
This script will replace all <br/> entries by #13#10 (CRLF)

#fileconversion #managedfiletransfer #filetransfer #filemanagement
If you need any help with this question, please let us know.
Best Regards,
Limagito Team
By Limagito-Team Conversion Pascal Script crlf, replace
05 Jan
How to remove the header row from a CSV file
How to remove the header row from a CSV file
Q: We have a CSV file that contains a header row. Is it possible for Limagito to remove the first row in the file when we move it to a new folder? Both the start and ending locations are on a windows server.
A: Yes, this is possible. Please have a look at the following screenshots.
The customer is using a Windows folder as Source so we used this also in our example:
We added an include filename filter so we are 100% we’ll only pickup .csv files:
In our Destination setup we added our ‘Pascal Script’ option:
Please add the following script (v1): link
We also added an alternative for the first script. In this script you can enable or disable the “TrailingLineBreak = finishing line break” (v2): link
psSaveListToFile(tmpList, tmpOutputFile, False);
psSaveListToFile(tmpList, tmpOutputFile, True);
We even added a third possibility where you can change the encoding and BOM of the resulting Csv file (v3): link
https://docs.microsoft.com/nl-be/windows/win32/intl/code-page-identifiers
psSaveTxt2File(tmpList.Text, tmpOutputFile, ‘UTF-8’, True)
If you would need a different option, please let us know, many options are possible.
RunTime Log Result:
#csv #managedfiletransfer #filetransfer #filemanagement
If you need any help with this ‘remove the header row’ question, please let us know.
Best Regards,
Limagito Team
By Limagito-Team CSV Pascal Script first, Header, remove, row