One Star

Postal address standardization

I want to change part of a text field, as in replace road with Rd or Street with St
4 REPLIES
Five Stars

Re: Postal address standardization

If this is all you want to do, you could simply use String.replace()
I'd write a Talend 'routine' so that you can change it as needed.
If you want to do more sophisticated address parsing, there may be an existing Java library that you can import.
One Star

Re: Postal address standardization

How do I do that?  It only seems to use suggested (canned) functions.
Five Stars

Re: Postal address standardization

When you've created the stub of your 'routine', right-click it in the repo and select 'edit routine libraries'
One Star

Re: Postal address standardization

hai all
6)Do the standardization
INPUT
EX: 3rd Circular St
veena st
St. Thomas mount st
mast road
stephan St.
Expected output:
3rd Circular Street
veena Street
st. Thomas mount street
mast road
stephan street
plss help me to get this output