@Nick-Brown

Yea, often posters just paste data into a posting without knowing what mangling a web site is going to do to it.

We recommend data be posted as a “code block” with the </> button in the composing toolbar, but asking for this seems to mystify a lot of people.

@Alan-Kilborn Thank you! That’s it… :) Since the blank dialogs only occur with the “old style” dialog, that should be no problem any more…

@Suvendu-Mullick

and this worked previously?? What did change?

@Evgeny-Morozov

Please restore your first posting in this thread.

Please don’t create other threads that are just a duplicate ( https://community.notepad-plus-plus.org/topic/20156/how-to-change-color-of-letters-of-highlighted-text )

@zlab-dxb ,

Notepad++ is a text editor, not a spreadsheet application. If you have an Excel file (.xlsx or similar extension), Notepad++ was not designed to handle that binary format, because Notepad++ is a text editor. I might recommend LibreOffice Calc or OpenOffice Calc as a free, open source spreadsheet program.

If what you have is a CSV file, then Notepad++ could theoretically open it, but so could the aforementioned free, open source spreadsheet programs. And oddly enough, spreadsheet programs are built to handle spreadsheets quite well.

If you really insist on editing a CSV spreadsheet in Notepad++, it could be done, though how complicated depends on your data, which you didn’t bother showing (if there is a comma in either column A or column B, things just got more complicated than I am going to help with)

For example, if you want to replace TWO from column A with whatever is in column B for that row in the CSV below:

COLUMN A,COLUMN B,COLUMN C ONE, 1.618, phi TWO, 2.718281828, e THREE, 3.14159, TWO, 2.0 END

You could use

FIND = (?-s)^TWO, (.*?)(?=,|$) REPLACE = $1, $1 Mode = regular expression REPLACE (twice) or REPLACE ALL (once) COLUMN A,COLUMN B,COLUMN C ONE, 1.618, phi 2.718281828, 2.718281828, e THREE, 3.14159, 2.0, 2.0 END

@Terry-R beat me to most of the overhead/caveats. I included one possible example to show how it might be done; with a simple CSV, you’d just have to use whatever data you wanted to match from COLUMN A instead of TWO. But depending on your data, it will be more complicated than I showed.

Please follow the advice below if you want help customizing this for your data.

----

Do you want regex search/replace help? Then please be patient and polite, show some effort, and be willing to learn; answer questions and requests for clarification that are made of you. All example text should be marked as plain text using the </> toolbar button or manual Markdown syntax. Screenshots can be pasted from the clipboard to your post using Ctrl+V to show graphical items, but any text should be included as literal text in your post so we can easily copy/paste your data. Show the data you have and the text you want to get from that data; include examples of things that should match and be transformed, and things that don’t match and should be left alone; show edge cases and make sure you examples are as varied as your real data. Show the regex you already tried, and why you thought it should work; tell us what’s wrong with what you do get… Read the official NPP Searching / Regex docs and the forum’s Regular Expression FAQ. If you follow these guidelines, you’re much more likely to get helpful replies that solve your problem in the shortest number of tries.

Hi, @mario-valle, @peterjones, @alan-kilborn and All,

I think that I understood the problem !

The bug occurs whatever the type of search is run ( Find All in Current Document, Find All in All Opened Documents or Find All ) I could reproduce the problem with N++ v7.8.5, 32 bits and the last version v7.9.0, 32 bits

It does not depend of the search mode Normal or Regular expression nor of the Word Wrap feature

Briefly : When the search concerns an expression, in a line of more than 1,002 characters and that you process successive searches, let’s say, 3 times, for the same expression or even an other one, a double-click on this long line, in the Find Result panel, moves to the concerned line of the concerned file, ONLY for the FIRST of the searches done ! Any double-click on this long line, in the subsequent searches, displayed in the Find result panel, does NOT work at all !

To reproduce the issue :

Download the bug.txt file of @mario-valle :

https://github.com/notepad-plus-plus/notepad-plus-plus/files/5378450/bug.txt

Open this file with Notepad++

First, deletes the end of the long line 4, which begins with Nelle nostre «Case dei Bambini», in order that the line contains exactly 1,002 characters ( not included line-break chars ! ). Personally, I ended this line with «bambini indipendenti» che 89012 to correctly see from the 998th to the 1,002th final character !

Run a first search of the word indumenti, clicking on the Find All in Current Document

Run a second search of the word spolverare, clicking again on the Find All in Current Document

Run a third search of the word indumenti, always clicking on the Find All in Current Document

In the Find result panel, right-click on the context menu and choose the Uncollapse All option

You can easily verify that a double-click at any part of these 3 lines, correctly, selects the right word, in the bug.txt file

Note that the two words spolverare and indumenti occur only once, in line 4 of @mario-valle’s file !

Then add just ONE character to the line 4 : I chose the digit 3 so the line ends with «bambini indipendenti» che 890123. Now, the line is 1,003 chars long, OK ! Redo all the process :

First, clear the Find Result panel, using the Clear All option, from the context menu

Run a first search of the word indumenti, clicking on the Find All in Current Document

Run a second search of the word spolverare, clicking again on the Find All in Current Document

Run a third search of the word indumenti, always clicking on the Find All in Current Document

In the Find result panel, right-click on the context menu and choose the option Uncollapse All

Now, double-click on each line of the Find result panel. It’s obvious that a double-click on the line, relative to the 1st search processed, works correctly. However, a double-click on the two other lines, relative to the 2nd and 3rd searches, produce nothing !?

Of course, I’m going to refer to this post in the GitHub issues 9009 and 8525 !

Best Regards,

guy038

@Venus642 said in Need help for regular expression - find, insert and delete:

Alan … your solutions is better

Well, I certainly wasn’t trying to “win”. :-)
I often try to point out that a solution to such a problem doesn’t have to be all crammed into one operation.
It can make the operation harder to understand for a novice with regular expressions.

Wow…
Worked Perfectly…

Thank you Verymuch…

@Jean-PROTEAUX ,

If you mean @Adriano-Ellero 's link from the very first post, the documentation has moved to https://npp-user-manual.org/docs/user-defined-language-system/

If you mean the links to https://www.adrianoellero.com/Capture.PNG, that image was probably temporary and deleted by the owner

@Oliver-Leidel
@patrickdrd
Try to install the previous version.

@PeterJones said in Notepad++ text selection "misbehaves" on 4K screen:

@Geoff-Hall ,

@Alan-Kilborn 's reply in another thread may be applicable to your problem as well, in that (unfortunately) the Notepad++ GUI codebase is pretty old, and doesn’t handle all the idiosyncracies of high-DPI monitors.

Knowing (now) that it is an old code base does seem to fit the observation. Pity. If I find I’ve got a lot of spare time I might look into it :P
In the meantime, at least I found a workaround.

@Alan-Kilborn said in Is 27333 magical?:

Since you seem to like to do some extra reading, that aspect of it is addressed HERE. Enjoy. :-)

BTW, the poster called “ghost” in that github topic is our old friend from here, @Claudia-Frank.
I know this because I had some separate notes on this regex problem, and my notes referenced Claudia saying something. Now when I look in that thread for her comments, they are attributed to “ghost”. I suppose she terminated her github account (for whatever reason), and when you do that, your old comments get reassigned to a ghost account.

The source code of the Notepad ++ program is here:
https://github.com/notepad-plus-plus/notepad-plus-plus

@Chuny_OK said in *Help* How to change multiple unknown text string with just one?:

If I want to replace “-12.5” with “11” at every found string, it actually comes up like this:

OK, some more changes required then. The latest revision of the Find What regex is:
(?s-i)(gameMinExposure.+?<value>).+?(</value>)
So in this instance I’ve put the 2 tags (<value> and </value>) around the “other” characters (number) that we need to replace. So the .+? does not care what currently exists in this position, but whatever is there will be replaced with the new number which you have in the Replace With field.

Terry

@Daniel-Soares ,

FIND WHAT = (?-s)\A^(.*\R){15}^.*?\K5 REPLACE WITH = [REPLACEMENT] REPLACE ALL (multiple times)

will change

5 one 5 0 3 5 two 5 0 3 5 three 5 0 3 5 four 5 0 3 5 five 5 0 3 5 six 5 0 3 5 seven 5 0 3 5 eight 5 0 3 5 nine 5 0 3 5 ten 5 0 3 5 eleven 5 0 3 5 twelve 5 0 3 5 thirteen 5 0 3 5 fourteen 5 0 3 5 fifteen 5 0 3 5 sixteen 5 0 3 5 seventeen 5 0 3

into

5 one 5 0 3 5 two 5 0 3 5 three 5 0 3 5 four 5 0 3 5 five 5 0 3 5 six 5 0 3 5 seven 5 0 3 5 eight 5 0 3 5 nine 5 0 3 5 ten 5 0 3 5 eleven 5 0 3 5 twelve 5 0 3 5 thirteen 5 0 3 5 fourteen 5 0 3 5 fifteen 5 0 3 [REPLACEMENT] sixteen [REPLACEMENT] 0 3 5 seventeen 5 0 3

If this is not sufficient, I suggest explaining yourself better with example before and after data formatted as data, and otherwise follow all the advice that I will quote below; if you choose to ignore some or all of this advice, you will find that the answers you get are not overly helpful, because you’re making us guess, and we will guess wrong (in total or in part).

----

Do you want regex search/replace help? Then please be patient and polite, show some effort, and be willing to learn; answer questions and requests for clarification that are made of you. All example text should be marked as plain text using the </> toolbar button or manual Markdown syntax. Screenshots can be pasted from the clipboard to your post using Ctrl+V to show graphical items, but any text should be included as literal text in your post so we can easily copy/paste your data. Show the data you have and the text you want to get from that data; include examples of things that should match and be transformed, and things that don’t match and should be left alone; show edge cases and make sure you examples are as varied as your real data. Show the regex you already tried, and why you thought it should work; tell us what’s wrong with what you do get… Read the official NPP Searching / Regex docs and the forum’s Regular Expression FAQ. If you follow these guidelines, you’re much more likely to get helpful replies that solve your problem in the shortest number of tries.

@Rowan-Sylvester-Bradley

It sounds like you are a victim of a long-standing Notepad++ problem.
It is likely that you will not be able to recover your data.
You might want to read all/some of THIS discussion thread.

All is not doom-and-gloom however.
There is supposedly a fix for the problem; however it isn’t in released code as of this writing; it will likely be in whatever is the next release after 7.9; probably 7.9.1.

@derezu-pezupop said in batch replace string with filename:

How can notepad++ replace each one with the filename in a batch operation?

I’m not on a PC at the moment but there was a post I was involved in solving some time ago to add filename to files. Have a read of
https://community.notepad-plus-plus.org/topic/17035/batch-function-need-to-add-filename-at-the-end-of-each-paragraph
and see if maybe it could, with some alterations, provide the solution for you.

Terry

@Ekopalypse

But testing this reveals that the layout gets switched but column selection still works :-(

@Christian-Lists

For such a case I use https://notepad-plus-plus.org/update/getDownloadUrl.php.

@donho But few UDL is not problem, what if someone has to make a lot of them and gets a trash on the menu?
https://github.com/notepad-plus-plus/notepad-plus-plus/issues/4896#issuecomment-706421610