@PeterJones said:

Welcom, @Massimo,

I am assuming those are really normal-quotes, not smart-quotes. Please see this awesome thread which explains how to use markdown to format your posts, so that the forum doesn’t change you important characters into smart characters.

Hi Peter, thanks for your help!

Are smart-quotes that in dabase are saved as

This worked perfectly!

Find

Replace with

Thanks again 😉

@Trevor-Friswell
there are a couple of ways of attacking this issue.

First would be to open the CSV file in a spreadsheet app, likely Excel, but Open Office would also work. This would then put each field in a separate column. Then you’d pick 1 column at a time and save the data to a txt file.

Second method is using Notepad++ to alter the data to suit by changing the commas separating each field into a “CR/LF”. I would also include an additional line feed at the end of each row, so that subsequent editing of the data could use this to help divide up the data in the separate files. Prepending a number at the beginning of each line (1 through 9) using the blank line would allow for a new sort of the lines to put them in the “file” groups. This is only a concept and may well require adjustment as one ventures through to a solution. Given some fields might have quotes around them if they have a comma within the data can further complicate matters.

Personally, given the small amount of information you have provided I would go with the Excel idea.

Note I haven’t actually provided any regexes (regular expressions) as obviously the example you provided is simplified (not real). All too often we try to help users where the information is limited, only to be told by the OP that in fact they “really need to do…” or that “the real data actually looks like…”. That is extremely frustrating and wasteful of time, often it can result in throwing out the solution, going back to the drawing board and designing another solution.

I would like to point you to our FAQ, specifically:
https://notepad-plus-plus.org/community/topic/15739/faq-desk-request-for-help-without-sufficient-information-to-help-you
Please read that and if needing to provide more realistic data use the formatting suggestion so that the interpreter here does NOT alter your data.

Terry

thanks @PeterJones , now i can reproduce.
(i barely use excel so i didn’t even now that you can put a tab or a new line in a cell ;-) )

now i definitively second your first suggestion using regex to replace the pairs of quotes:

If you only want to get rid of matched quote pairs, then enable search mode = regular expression, and set find what=“([^”]*)" and replace with=$1. (edit: to clarify, the quote marks around the parenthesis are part of the search-string, so you should type those, too)

Thanks to everyone who helped with this question. Each answer contributed to the solution. Special thanks to guy038 who gave me a better understanding of how the code works and his solution worked perfectly.

Ray Fellers

@trace-calvin
XButton1 - 4th mouse button. Typically performs the same function as Browser_Back.
XButton2 - 5th mouse button. Typically performs the same function as Browser_Forward.

So NPP cycles back through tabs on both Browser_back event and Xbutton1 event. I didn’t find any option to disable or change it. If it bothers, you can use Autohotkey script to change this button, or block completely with this script:

Hello, @олег-выползов,

Just one question :

When you just mouse select this string $c_word, in current file, do you see, in the status bar, at the bottom of N++ window, the indication Sel 7|1 ?

If you get a value above 7, this would mean that the string $c_word, itself, contains one or several invisible chars !

Best Regards,

guy038