Skip to main content
Solved

How to remove double quotes from a CSV integration when opened with notepad++

  • January 11, 2023
  • 1 reply
  • 496 views

Forum|alt.badge.img+5

I am trying to do a CSV integration export in which when opened in Notepad ++, it doesn’t have leading quotes (“). I am trying to send this file every week to a customer via EDI for billing and the testing keeps failing because of this.

Attached is the integration I am testing and the file with the issue.

Best answer by GDFMNICHOLS

The CSV integration map includes quotes around each line. This is not the case with a Flat File map. So creating a Flat File integration and switching over all the components to the new integration map will resolve the issue.

1 reply

Forum|alt.badge.img+5
  • Author
  • Do Gooder (Customer)
  • 6 replies
  • Answer
  • January 12, 2023

The CSV integration map includes quotes around each line. This is not the case with a Flat File map. So creating a Flat File integration and switching over all the components to the new integration map will resolve the issue.