Remove quotation marks from string

[jpages]

Hello,

I have a .csv with random quotation marks in it. I need to remove them for importing the data in a postgres server, otherwise I’m having quote errors.

I tried the manipulation node with remove function, but It doesn’t work.

Any ideas? Thanks!

[aworker]

Hi @jpages and welcome to the KNIME community

The solution to add special characters within the quotes of a string in many of the scripting nodes such as in the -String Manipulation- node, is to scape it (protect it) using a\ sign. For instance, in your case, you will need to instead write:

removeChars(column, "\"")

and then the quote should be correctly interpreted.

Hope this helps.

Best

Ael

[izaychik63]

Try “”" as double quote is a special symbol.