Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 '|')