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.
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