I have a list of about 80 values that I need to check within a data fields in a SQL Server database and replace the values with something different. For instance in a couple of address fields I want to change Street to ST, Road to RD, Avenue to Ave, etc. I am using a tReplace to find and replace smaller sets of values but I am looking for a solution that would use a longer list of values. Is there a way of doing this that someone could suggest and give an example for?
Also, is Talend case sensitive in a windows environment? In my file would I have to enter "STREET", "Street" and "street" or could I just use "Street" to search for the value I want to replace?
My project uses java and uses a SQL Server database.