how to extract the pincode from the address field

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.

 

 

Forteen Stars

Re: how to extract the pincode from the address field

You can write routine or you can write a if else condition with hard coded pincode to pupulate pincode in tmap
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Moderator

Re: how to extract the pincode from the address field

Hello,

Please stick to one topic:https://community.talend.com/t5/Design-and-Development/how-to-extract-the-pincode-from-the-address-f...

In this way, we can pay individule attention to your issue.

Feel free to let us know if you need to move your duplicated topic.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download