Extract word after specifying blank space

Hi Expert,

In a given cell I have following sample data that runs in thousands rows but in one column

Task is to pull out any word (DXB or ABU in this case) that is 3rd from right, only if cell has 4 blank spaces in between two words or cell has 5 words in total

SYD EK DXB EK SYD
ADL EK DXB EK DEL
ISB EY ABU EY MEL




Task is to pull out 5th word (LGW or LON in this case) , only if cell has 8 blank spaces in between two words or cell has 9 words in total

PER EK DXB EK LGW EK DXB EK PER
SYD EK DXB EK LON EK DXB EK MLE

Rows runs in mix of above two

Currently I use following function to pull out specific words

=IF(COUNT(SEARCH("DXB",A1)),"DXB"," ")

Request for any function that may be able to assist based on blank spaces

Thanks
Karnik

Hi Sandy666 and Alkey

Thanks for your time and expertise , solution works brilliantly
Cheers
Karnik

Hi Expert,
I am back again with same issue, but different challenge

Function for cell that contains fix data characters 17 (including blank space ) given below in 1st 6 rows to pull out only last 3 characters only
Function will ignore cell that has more that 17 character cells e.g. last to rows

DATA RESULTS REQUIRED
SYD EY AUH EY BEG BEG
SYD VA SIN VA CDG CDG
SYD VA SIN VA CDG CDG
BNE TG BKK TG BNE BNE
BNE TG BKK TG BNE BNE
SYD TG BKK TG SYD SYD



BNE DL LAX DL YVR DL YYC DL SLC DL LAX DL BNE (to be ignored)
PER EY AUH EY LHE EY AUH EY PER (to be ignored)


Thanks in advance

Hi MarvinP,

It works!
Thanks for simple solution, in fact I will use modify command to pull out desired results
Cheers
Karnik