Skip to main content
Solved

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

  • January 11, 2023
  • 1 reply
  • 490 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.

View original
Did this topic help you find an answer to your question?

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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings