Remove quotation marks from string

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.

image

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

image

Any ideas? Thanks!

1 Like

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

6 Likes

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

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.