To get information from a file name you can create a manifest on the fly. Here is an example for a similar request. A customer would like to extract ABC and 32ex as variables from a pdf with this name:
FO146390_ABC_49180_5214_32ex_SRA3_Komplett.pdf
This PowerShell script that you need to run on a hotfolder with parameters $FFin$ and $FFout$ will create a manifest extracting the required information from the file name using two regular expressions ($regex1 and $regex2) and write those into columns in the manifest. The variables can then be used as for instance in a Watermark.
$filepath = Get-Item $args[0]
$filename = $filepath.Name
$maxfile = "C:\Temp\$filename.txt"
$regex1 = '^.*?_(.*?)_.*?_.*$'
$regex2 = '^.*?_.*?_.*?_.*?_(.*?\d*).*$'
$preset = ($filename -split $regex1)[1]
$copies = ($filename -split $regex2)[1]
Copy-Item $filepath -Destination "C:\Temp\"
Set-Content -Path $maxfile -value "C:\Temp\$filename;$preset;$copies" -NoNewLine
$outpath= $args[1].Substring(0,$args[1].Length-1)
Copy-Item -Path $maxfile -Destination $outpath
You would need to find the correct regular expression for the information you would like to extract from the file name. Here is one https://regex101.com/ or google regex tester.
For something like:
123xsomefilename210mm.pdf
\d+(?=x) would give 123 and x*(\d+)(?=mm) would give 210
/Stefan
