How to fetch postal code from the Text which come next to Addresss always

Always the postal code come at last
If we found two numbers with (4 bit size) search for last one or second one.
eg: O 0605 ADDRESS 11 DOUGLAS STREET, EARLWOOD, 2206, AU TEL 00610413851435
In this example need to fetch 2206(second one)
once last postal code (eg:2206) is fetched we have to search in below excel file
whether the fetched postal code is existed in excel file or not.(ZIP file is given)
If existed then print the postal code.
If not existed check for another postal code.
SYD.zip (23.3 KB)

O 0605 ADDRESS 11 DOUGLAS STREET, EARLWOOD, 2206, AU TEL 00610413851435

141 WHALE BEACH RD SYDNEY 2107 447789956904 PAX RQSTD VAN WITH 2 CAR SEAT

O 0655 ADDRESS 172 BUNDARRA ROAD BELLEVUE HILL NSW 2023 * ANGELA *** TEL 61413378835

O 0605 ADDRESS 6 SEAFORTH AVENUE WOOLOOWARE NEW SOUTH WALES 2230 AUSTRALIA NEED BOOSTER SEAT FOR CHILD 2YRS TCP B4TJSS ** TEL 0061481914980

LHR.MERITON SUITES KENT STREET 528 KENT STREET NSW 2000 4407811604788

SYD.UNIT 1808 36 TO 46 COWPER STREET PARRAMATTA 2150

CDG.6 COWPER WHARF ROADWAY WOOLLOOMOOLOO NSW 02011 61447526229

Hi,

Hope the following sample helps you.

Sample20221105-1.zip (29.9 KB)

Regards,