I have a list and folder of pdf files and they are effectively invoicenumbers.pdf . I need to add a custom prefix to the invoices depending on their exact number as a prefix which is a audit trail number needs to be added to the file name. So if a audit number is 10001 and relates to invoice ABCDEFG then I need BRU to find ABCDEFG.pdf and then check what prefix is needed and then rename the file to 10001 ABCDEFG.pdf.
The Audit trail numbers are related to the filename less the extension name, I have spent a while trying to see how this can be achieved.
Any Super users out there?