topic Remove double quotes in Talend Studio

Remove double quotes

Anonymous — Wed, 28 Dec 2016 07:05:54 GMT

Hi,
how to remove the double quotes in Talend from the source fields.
EX: Coulmn1- "Hi" and column2- "Hello"
Output should be : Column1-Hi and Coulmn2- Hello

Thanks,

Re: Remove double quotes

Anonymous — Wed, 28 Dec 2016 07:49:43 GMT

Hi
You can use this expression on tMap or tJavaRow:
row1.columnName.replaceAll("\"","")

Regards
Shong

Re: Remove double quotes

Anonymous — Wed, 28 Dec 2016 08:07:36 GMT

Hi,
thanks for your reply. it works fine now.
i have source field value like "Test-First-Job", needs to extract the last chars of the word after the last "-".

it should be like : "Job"

Thanks,

Re: Remove double quotes

Anonymous — Wed, 28 Dec 2016 09:39:35 GMT

You need to cut the string from the last index of "-":
row1.newColumn.substring(row1.newColumn.lastIndexOf("-")+1)