topic Re: Can Talend use an external file to search and replace values in Talend Studio

Can Talend use an external file to search and replace values

Anonymous — Sat, 16 Nov 2024 14:04:58 GMT

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.

Re: Can Talend use an external file to search and replace values

Anonymous — Sat, 07 Feb 2009 23:02:32 GMT

This is exactly what tReplaceList does. And yes it can be case insensitive or not, depending on your will (I mean there is a checkbox), not on the environment you're running on.

Re: Can Talend use an external file to search and replace values

Anonymous — Mon, 09 Feb 2009 16:41:07 GMT

This solution sounds great but I seem to have a problem implementing it. I am using java and I'm not sure if this is a perl only solution. I found the user documentation for tReplacelist and I am trying to implement it without receiving the results I expect. My goal is to change names to abreviations for street names. For instance from "123 Main Street" I would like to get "123 Main ST". In my delimited file I have the entry
" STREET ";"ST". I have tried with " STREET ";"ST" and "STREET";"ST". I would like to change values within a text string and not the entire string. Am I missing something?

Re: Can Talend use an external file to search and replace values

Anonymous — Mon, 09 Feb 2009 17:18:15 GMT

After some more experimenting, I found that I should not use double quotes(") in the delimited file. I updated my delimited file and the replacement works great!

Re: Can Talend use an external file to search and replace values

Anonymous — Wed, 04 Apr 2012 18:39:03 GMT

Hi
hi i am using tReplaceList, but it is creating problem, if My Look-up file has string like
ShortName|FullName
NA | NAME
ME | Meet End
but first look-up finds the NA and Replace with "NAME" in main stream, but same "NAME" string contains "ME" so also replace with "Meet End" and so on
then out put looks like " NAMeet End" this is a small example.
please suggest how to replace once and then move for next main row?

Re: Can Talend use an external file to search and replace values

Anonymous — Wed, 12 Feb 2020 11:05:24 GMT

SA,E QUESTION