Help with Correct regex

I am trying to parse a pdf but I am unable to get all the records parsed as I want.

Apologies, am really weak at REGEX so I am not able to get exactly as I want.

I have included the expected output against the actual output from the pdf as attached. The missing fields are highlighted in yellow as per the xlsx file attached.

Help would be greatly appreciated.

Also, any tips/tutorials on how I can develop on my regex skills would be also of huge help.

Thanks.

Parsing PDF Invoice.yxzp

PDF Parse_output_Expected.xlsx

Regex

Data Investigation

Accepted answers

Qiu

@HW1

Have something for you.

Please note that it is highly sensitive to your input.

Parsing PDF Invoice-R1.yxzp

All comments

Qiu

@HW1

How come

BP Warrego Highway is not an address

while
1505 Warrego Highway is one?

HW1

@Qiu Yep, you are correct.
But, 'BP Warrego Highway' is the name of the site and not the address. All addresses start with a number hence it is correct in not identifying it as an address.
Just like 'Med-X Clarence Correctional Centre' is the name of the site and not an address. The address is in the next row.

Can you help me with the correct regex in this case?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703