topic Re: Regextest in QlikView

Regextest

QlikView_99 — Thu, 12 Sep 2019 15:07:17 GMT

Hello All,

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

Re: Regextest

StarinieriG — Thu, 12 Sep 2019 15:10:27 GMT

try to use this expression

SubField(SubField(field,',',-1),' ',-1)

Re: Regextest

QlikView_99 — Thu, 12 Sep 2019 15:15:33 GMT

No, I want to test if there is a pincode in the address in some cases the address columns are in the below way.

Cannon Street, 25 Walbrook, London, EC4N 8AF

27 Poultry (Meet By Turkish Bank In Princes Street), London, EC2R 8AJ

1-7 Snowsfields, LONDON

The Grove, Chandlers Cross, RICKMANSWORTH

*st Pancras Eurostar

Re: Regextest

StarinieriG — Thu, 12 Sep 2019 15:19:27 GMT

You could test with len

If(Len(SubField(SubField(field,',',-1),' ',-1)=3,'Pincode','Missing')

But you have to be sure about len

Re: Regextest

QlikView_99 — Thu, 12 Sep 2019 18:12:57 GMT

What if i want to specify the length between some range for suppose i want to get the for some pincodes are 3 digits and some are 4, could you please help me with this?

Re: Regextest

StarinieriG — Fri, 13 Sep 2019 07:03:20 GMT

If(Len(SubField(SubField(field,',',-1),' ',-1)=3 or Len(SubField(SubField(field,',',-1),' ',-1)=4,'Pincode','Missing')