topic Re: Postal address standardization in Talend Studio

Postal address standardization

Anonymous — Thu, 12 May 2016 18:41:45 GMT

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

Re: Postal address standardization

Anonymous — Thu, 12 May 2016 19:45:33 GMT

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.

Re: Postal address standardization

Anonymous — Thu, 12 May 2016 20:06:23 GMT

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

Re: Postal address standardization

Anonymous — Thu, 12 May 2016 20:11:49 GMT

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

Re: Postal address standardization

Anonymous — Tue, 18 Oct 2016 06:49:34 GMT

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