AnsweredAssumed Answered

Create Metadata from Filename

Question asked by cooked77 on Aug 8, 2018
Latest reply on Aug 31, 2018 by emha

Hi everyone

 

I have a workflow which creates metadata from the filename.  This is mostly simple just using Build String and counting characters.  I have a challenge though when trying to extract a customer name from the file name, for example: "Invoice 11111117 for Order 1011111 for Customer ACME International  Flavours Ltd.pdf" - this is due to customer names obviously not all being the same length so I cannot just count characters like I would to get the Invoice Number or Order Number as these are always fixed lengths at the same place in the file name.

 

Is there a way to get the customer name out, even though the character counts would be different for almost every file name?

Outcomes