September 2023 - Page 3 of 3 - 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
How to use a wildcard in the excel sheet name
Q: How to use a wildcard in the excel sheet name. I am using the below to split and convert the tabs out of a spreadsheet but every now and again the client gets the sheet name slightly wrong.
Can you use a wildcard in the sheet name option?
Example:
2 Sticker*
A: Added on request and available in v2023.8.12.0
Example where we used: Page*
If you need any info about this ‘wildcard in the excel sheet name’ request, please let us know.
#excel #filetransfer #filemanagement
Best regards,
Limagito Team
By Limagito-Team XLS/CSV excel, sheet name, wildcard, xls
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