The thing is, you want to keep the carriage returns, and just get rid of the quotes.
If you copy and paste from Excel into Word, that gives you the correct output. You can then copy and paste it from Word to wherever you want, like Notepad, or Notepad++.
So the question is, what is Word doing that it can handle this - getting rid of CSV characters . . . how does it do this?
I see that there are a lot of question on this out there. I have the question in to Notepad++, as to if it has a setting, or if there is a plugin:
https://notepad-plus-plus.org/commun...t-extra-quotes
I know that when you export from Excel, you can set text delimiters. No changes there would help in this situation of copy and paste . . .
I wonder if there's a setting in Word that if you un-checked it, then you would see the quotes. That would indicate how it's currently doing what it does correctly.
Bookmarks