Rename Archives - Page 3 of 4 - File transfer tool from Limagito

15 Sep
How to rename a file keeping the last 7 characters intact
How to rename a file keeping the last 7 characters intact
Q: I need assistance to set up a move rule and rename the file to the destination. The file name needs to keep the last 7 characters intact before the file extension name. For example if the original file name is “Aspect Windows Pty Ltd_398x272_1531309.pdf” – we need it renamed to “1531309.pdf” before it is moved to the destination directory. Any idea how I can set this up please?
A: This is possible using our Destination file renaming option
Please enable and setup ‘Rename Files during Copy/Move’ in your Destination setup:
RegEx: (.*)(.{7})\.(.*)
Replacement: \2.\3
Information about how to use regular expressions can be found here.
If you need any info about this request, please let us know.
#filetransfer #filemanagement
Best regards,
Limagito Team
By Limagito-Team Rename last characters, rename
08 Sep
Query around filename to directory name
Q: Query around filename to directory name. Reaching out just in case you have an easy way to assist for this one:
We have a rule which currently picks up files from a SFTP source and drops them into an S3 bucket.
Here are a sample of the source filenames:
(64506930) 87268700 20230826.pdf
(64506930) 87268701 20230826.pdf
(568454) 87282612 20230831.pdf
This works, however we would like to drop them into a folder based on the {accountId} which is between the brackets:
However we can’t rely on the filename begin and end positions as the accountId isn’t always the same length.
Is there an easy answer to use a regex or something to select the accountId from between the brackets?
Please let me know if you have any queries.
A: In your Destination setup please adjust the ‘Create Subdir option’ to: %SFN
Enable ‘Rename Destination Subdirectory’ and open ‘Rename Filter Setup’
Directory Renaming Setup:
RegEx: \((.*)\)(.*)
Replacements: user/\1/invoices/
RunTime Log Result:
Feedback Customer:
Just a quick email to say thank you! I only reach out to support occasionally – and each time I’m surprised at the level of support provided.
If you need any info about this ‘filename to directory name’ request, please let us know.
#mft #filetransfer #filemanagement
Best regards,
Limagito Team
By Limagito-Team Rename directory name
29 Jun
How to increment the date in a filename by plus one day
Q: Is it possible to rename a file containing a date string when copying it to increment the date in the filename by plus one day?
where yyyymmddxx_I.p1.pdf the yyyymmdd will increase by +1
Examples
Input: 2022010501_I.p1.pdf
Output: 2022010601_I.p1.pdf
Input: 2023123101_I.p1.pdf
Output: 2024010101_I.p1.pdf
A: Yes this is possible. Please have a look at the following screenshots.
We used a Windows folder as Source (can be any other type of Source too):
Open our Pascal Script option:
Enable and Add the following ‘On Destination’ Pascal Script:
Var tmpFilename, tmpDateStr: String; tmpDate: TDateTime; Const ctDateFormatOld = 'YYYYMMDD'; ctDateSepOld = #0; ctDateFormatNew = 'YYYYMMDD'; Begin (* Example: Input: 2022010501_I.p1.pdf Output: 2022010601_I.p1.pdf *) psExitCode:= 0; // ... add your code here tmpFilename := psFilename; If length(tmpFilename) >= 8 Then Begin Try tmpDateStr := Copy(tmpFilename, 1, Length(ctDateFormatOld)); tmpDate := psStrToDate(tmpDateStr, ctDateFormatOld, ctDateSepOld); tmpDate := psIncDay(tmpDate, 1); psVSA := FormatDateTime(ctDateFormatNew, tmpDate); psExitCode:= 1; Except psLogWrite(1, '', 'Strip Date from File exception on ' + psFilePath + psFilename); End; End Else Begin psLogWrite(1, '', 'Strip Date length of File error on ' + psFilePath + psFilename); End; End.
Open our Destination setup
We used a Windows folder as Destination:
Enable ‘Rename Files during Copy/Move’ and click the ‘Rename Filter Setup’ button:
Add the following ‘File Rename’ setup:
RegEx: .{8}(.*)
Replacement: %VSA\1
RunTime Log result:

#mft #Filetransfer #rename
If you need any info about this “increment the date in a filename” request, please let us know.
Best regards,
Limagito Team
By Limagito-Team Pascal Script Rename increment date