Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Remove double quotes

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,

Labels (2)
3 Replies
Anonymous
Not applicable
Author

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

Regards
Shong
Anonymous
Not applicable
Author

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,
Anonymous
Not applicable
Author

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