Hi all, I’m hoping some clever chap or chapess can solve what is probably a simple task but is driving me mad. I am reading PDF invoices and trying to extract the customer name to use as the filename. I have an expression that works in RegEx Builder using test text, but when the file is run it returns null.
Sample text:
"@"Invoice
Date Invoice #
01/01/2022 23
Bill To Terms 21 days
ACME Company Ltd
Unit 2016
The Residences
Description Amount"
In the example above I want to return “ACME Company Ltd” and in the RegEx Builder I can achieve that with the following expression, which (I think) asks it to match anything between " days" and "Unit " ignoring new line returns in between.
(?<= days\n)[\S\s]*(?=\nUnit )
As I say, it works in the builder but not when I run it - any help is very much appreciated.