topic Re: Find Postcode in string address in App Development

Find Postcode in string address

Valerie — Sat, 16 Nov 2024 03:58:59 GMT

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?

Re: Find Postcode in string address

tresB — Fri, 29 Nov 2019 07:10:28 GMT

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 '|')