• 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

    rename a file keeping

    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 ,
  • 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.

    wildcard in the excel sheet name

    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*

    wildcard in the excel sheet name

    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 , , ,
  • 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:

    filename to directory name

    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

    limagito file mover destination subdirectory option

    • Enable ‘Rename Destination Subdirectory’ and open ‘Rename Filter Setup’

    limagito file mover rename directory option

    • Directory Renaming Setup:
      RegEx:  \((.*)\)(.*)
      Replacements:   user/\1/invoices/

    filename to directory name

    • RunTime Log Result:

    limagito file mover 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
1 2 3
SEARCH