Pascal Script Archives - Page 5 of 29 - File transfer tool from Limagito

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
30 Dec
Split delimited files based on duplicate column
Split delimited files based on duplicate column
Q: We receive | (pipe) delimited files (no double quotes):
Rvman International Inc. – US|CONTENT + US|1310001|0000000122|10/25/2023 1:54 PM
Rvman International Inc. – US|CONTENT + US|1310002|0000000616|0/25/2023 2:10 PM
Rvman International Inc. – US|CONTENT + US|1310002|0000000616|0/25/2023 2:10 PM
Is it possible to create separate files of rows with the same content in column 4?
The filename(s) would be incremental:
original .csv
Rvman International Inc. – US|CONTENT + US|1310001|0000000122|10/25/2023 1:54 PM
original1.csv
Rvman International Inc. – US|CONTENT + US|1310002|0000000616|0/25/2023 2:10 PM
Rvman International Inc. – US|CONTENT + US|1310002|0000000616|0/25/2023 2:10 PM
Thanks for such a great product!
A: Yes this is possible using our Pascal Script option
We used a Windows folder as Source. In this folder we’ll search for .csv files.
Since we are only interested in .csv files we added a filename include filter. We want to be sure we’ll only handle .csv files.
As Destination we used our Pascal Script option. Please replace the default Destination Pascal Script.
You can download the script: here
The script will read the csv file with a pipe as delimiter (this can be adjusted > ctPipe constant). We’ll check the content of column 4 which is index 3 (TStringList = zero index based).
tmpCol4 := tmpPipe.Strings[3];
Output Result:
RunTime Log Result:
#csv #managedfiletransfer #filetransfer #filemanagement
If you need any help with this ‘Split delimited files based on duplicate column’ question, please let us know.
Best Regards,
Limagito Team
By Limagito-Team CSV Pascal Script csv, pipe, split delimited