Okay, so, assuming you always have a batch number, you can get the net weights per unit with the following regex:
(?<=Batch\s[0-9A-Z]+\s+)\d+\.\d+
And then you just keep building on this same regex by moving the decimals into the positive lookbehind, so that you exclude that, but pick the next one:
- Gross weights per unit - (?<=Batch\s[0-9A-Z]+\s+\d+\.\d+\s+)\d+\.\d+
- Net weights total - (?<=Batch\s[0-9A-Z]+\s+(\d+\.\d+\s+){2})\d+\.\d+
- Gross weights total - (?<=Batch\s[0-9A-Z]+\s+(\d+\.\d+\s+){3})\d+\.\d+
The following regex will get you the product descriptions: [A-Z]+(\r?\n.+){4}Batch\s[0-9A-Z]+ but this will include some of those blank lines between the text, so you will need to do some text processing to clean those.
If you need the quantity in the brackets, you can get that with \(\s.+\)
If you need the delivery plant, too, you can get it as Delivery\sPlant\s:\s[A-Z0-9]+
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
