how to extract the pincode from the address field

Highlighted
Five Stars

how to extract the pincode from the address field

Hi,

I tried to get the pincod which has given in the last in the address field.

but i couldn't able to get the pin codes which are given in the middle of the address field.

example

 

513B,5TH FLOOR,MINERVA COMPLEX, SAROJINI DEVI ROAD, SECUNDERABAD Andhra Pradesh INDIA 500003
FALT NO.501, PADMANABHA APARTMENTS PEDAWALTAIR VISAKHAPATNAM Andhra Pradesh INDIA 530017
77/2,GURAVARAJUPALLE VILLAGERENIGUNTA-SRIKALAHASTI ROAD RENIGUNTA Andhra Pradesh INDIA 517520
S-6,CLASSIC COMPLEX,PRAKASARAOPETA VISAKHAPATNAM-530 020. Andhra Pradesh INDIA

if you see in the 4th row the pin code is not at last.how to extract  such pin codes.

Note here the string is separated by commas and sometimes with space missed are there.

Any idea is very help to me.

 

 

Nine Stars

Re: how to extract the pincode from the address field

Hi,

are you looking for the following output?

zipcode.PNGzipcode1.PNG

Assuming that zipcode will be present in last field of sting with "," delimiter.

Regards,

 

Veeru Boppudi
Five Stars

Re: how to extract the pincode from the address field

yes actually.

But the thing is the addresses are seperated some by  comma (,)and  some address are separated by space ( )delimiter also. At that time how we can split. please suggest any idea.

Nine Stars

Re: how to extract the pincode from the address field

Please provide sample data for your requirement.

 

Regards,

Veeru Boppudi
Five Stars

Re: how to extract the pincode from the address field

Hi,

 Thank you very much !

suppose the address field

has

 

  1. A-125  vertex somagiguda hyderabad-500085
  2. F/89,hythnagar-500038, hyderabad India.
  3. TALLE VALLEY ROAD HAPLI ZERO LOWER SUBANSIRI Arunachal Pradesh INDIA 791120
  4. BOMMIDALA HOUSE, D.NO.5-87-15/A. LAKSHMIPURAM MAIN ROAD, GUNTUR-522 007 A.P. Andhra Pradesh INDIA

like that the address field is separated by comma,some times space and the pin codes in between.

 

Actually i solved in following way

 

first i extract only numeric then last 6 characters,then valid pin codes by lookup table with all region pincodes all region pincodes.  with this logic i could able. to get the pin codes.

 

the problem is partially y solved.

 

And Thank you for the reply