How to set an escape character for embedded quotes

I have text data that contains quotes. Currently, the output from EDT places an additional quote around the data (i.e., “” instead of the normal “). I need to use escape character (i.e., “\” in front of the quote so that the output is \”. instead of “”

How can I do that?

Is this for output to CSV? Double quoting is the usual way to escape commas in a CSV file. But you should be able to:

  • replace " with " using Replace
  • output to CSV with Quoting set to Never

For a simple example see quoted.transform (1.8 KB)