Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Postal address standardization

I want to change part of a text field, as in replace road with Rd or Street with St
Labels (2)
4 Replies
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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

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

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