Find Postcode in string address

[Valerie]

I would like to get postcode from the string of address

Address	Postcode
1 G LORONG DELIMA 17, ISLAND GLADES, 11700 GELUGOR, PULAU PINANG	11700
1 JALAN 5/36 SEKSYEN 5 BANDAR RINCHING 43500 SEMENYIH SELANGOR	43500
1 & 2 LOT 2000 JLN JAM  BU BATU 71/2 MERU 42200 KLANG SELANGOR	42200

Result is Postcode column.

Postcode is a fixed number of digit, anyway to get this 5 digits number from string of text?

[tresesco]

One way could be like:

Load
	*,
	SplitBySpace as PostcodeFinal
	Where Len(SplitBySpace)=5 and IsNum(SplitBySpace);
	
Load  *,
	SubField([Address	Postcode], ' ') as SplitBySpace
	Inline [
Address	Postcode
1 G LORONG DELIMA 17, ISLAND GLADES, 11700 GELUGOR, PULAU PINANG
1 JALAN 5/36 SEKSYEN 5 BANDAR RINCHING 43500 SEMENYIH SELANGOR
1 & 2 LOT 2000 JLN JAM  BU BATU 71/2 MERU 42200 KLANG SELANGOR
] (delimiter is '|')