topic [resolved] Change function in tmap in Talend Studio

[resolved] Change function in tmap

Anonymous — Thu, 10 Dec 2015 06:47:56 GMT

Hi team ,
StringHandling.CHANGE("Adwit_S1795 (add)","adwit_","AC")|| StringHandling.CHANGE("Adwit & Sukta PLC SP1","adwit &sukata","ACC1")
Like this I have many values in row.customer_Name ,which I need to replace but I m getting below error . please help

Exception in thread "main" java.lang.Error: Unresolved compilation problem:
The operator || is undefined for the argument type(s) java.lang.String, java.lang.String

Re: [resolved] Change function in tmap

Anonymous — Thu, 10 Dec 2015 08:12:17 GMT

Hi
You can not use the operator || in a String field, try to change your expression to:

StringHanding.CHANGE(StringHandling.CHANGE(row1.customer_name,"adwit_","AC"), "adwit &sukata" ,"ACC1")

Re: [resolved] Change function in tmap

Anonymous — Thu, 10 Dec 2015 08:27:06 GMT

thank you shong , I am able to achieve this using treplace (processing) component