Remove only double quotes from the beginning and end of a string

[pawe84]

Hi everyone in a csv file there is a column which contains a description text.

Because this csv was exported from another system the string has exclamation marks like this:

"New 23" screen, HDMI ..."

How I can remove the first and the last double quotes of a string?

When I use t_replace then in my description the quote of ...23" screen.. will also be replaced.

Can I trim the string so that only the first and last character will be removed? Maybe inside tmap or tjava_row?

Thanks fpr your help.

[Talend_ent]

use StringHandling.EREPLACE("column_name", """, "")

I think this is your column data "New 23" screen, HDMI ..."

[vikramk]

we cant use StringHandling.EREPLACE() here, because he wants the output as this:

New 23" screen, HDMI ...

Try to make use of left and right functions to remove double quotes at the end