I'm having trouble in getting an alphanumeric word from a string, i have a column with addresses and i need to know whether the last word in that whole string is a pincode. so last word in the below column after ", " is a pincode.
Cannon Street, 25 Walbrook, London, EC4N 8AF
27 Poultry (Meet By Turkish Bank In Princes Street), London, EC2R 8AJ
1-7 Snowsfields, LONDON, SE1 3SU
The Grove, Chandlers Cross, RICKMANSWORTH, WD3 4TG