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.
|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.
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables