Limagito File Mover Software Blog and Filemover News

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
07 Jan
Replacement Parameter File Created Date for Source File
Replacement Parameter File Created Date for Source File
Q: I see options in the Replacement Parameters for the Source, File Modified Date but I would also like the option for the Source, File Created Date. Is that something that can be added?
A: We added this option in version v2024.1.7.0
Parameters, Added %SFA Source File last Acces time
Parameters, Added %SFB Source File Birth (= creation) time
As a test we added the new parameters in our WIN as Destination setup. These new parameters will be used to create a subdirectory:
Reminder: What are the Date & Time parameters that we can use?
RunTime Log Result:
Output Result:
We also added some extra Pascal Script DateTime var linked to Source File Last Access, Creation and Modified Times:
psFileADateTime variable = Last Access Time
psFileCDateTime variable = Creation Time
psFileMDateTime variable = Modfied Time
An example of using these new Var in our Pascal Script as Destination option:
#managedfiletransfer #filetransfer #filemanagement
If you need any help with this ‘Replacement Parameter File Created Date’ question, please let us know.
Best Regards,
Limagito Team
By Limagito-Team Parameters file created date, parameter, parameters
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