SFTP source file pattern

A regular expression pattern used to identify the files to copy from the SFTP server, starting in the SFTP source directory. The file pattern can include capturing groups, which are regular expression groups within parentheses. The pattern can then be used by the SFTP target file pattern property to reference the captured groups.

Files are automatically deleted from the SFTP server after being transferred.

Length
Up to 255 characters (bytes)
Default
If no value is specified, all files in the SFTP source directory, including its subdirectories, will be copied.
Database name
SftpInput.SourceFilePattern

Examples:

The file pattern [a-z0-9]+\\.[a-z]+:

  • Matches the file abc38.pdf
  • Does not match the file Abc38.pdf
  • Contains no captured groups available to use in the SFTP target file pattern property

The file pattern [a-zA-Z0-9]+/[a-zA-Z0-9]+/[a-zA-Z0-9_-]+\\.[a-zA-Z0-9]+ :

  • Matches these files:
    • Xyz/Abc/File1.pdf
    • Xyz2/Abc2/File_1-C.pdf
    • Company1/Letters/Letter1.pdf
    • Company1/Invoices/Act027823_10-2017.pdf
  • Does not match these files:
    • Xyz/Abc/File1
    • Company-1/Letters/Letter1.pdf
    • Company1/Invoices/Act027823.10-2017.pdf
  • Contains no captured groups available to use in the SFTP target file pattern property

The file pattern ([a-zA-Z0-9]+)/([a-zA-Z0-9]+)/([a-zA-Z0-9_-]+)\\.([a-zA-Z0-9]+):

  • Matches the file Company1/Invoices/Account027823_10-2017.pdf
  • Allows captured groups 1, 2, 3, and 4 to be used in the SFTP target file pattern property to create a file with the following values:
    • 1 = Company1
    • 2 = Invoices
    • 3 = Account027823_10-2017
    • 4 = pdf

Parent topic: Field help