I should have added to my previous post:

Forget the bookmarking idea entirely; it isn’t useful to the task at hand.

@alimirzaei5778 said in How to calculate average for XML attributes which their value equal to zero using the before and after values:

Any help would be appreciated.

Learn a programming language and how to program.

Seriously, that’s the way.

@jason-sederquist said in Trouble searching and finding "same" but unique strings...:

I cannot place images in the compose box, nor reply to YOUR post…

When replying to a post, you normally either select something in the post you replying to (you’ll see some reference in my one to some text in yours) or just click on the “reply” text (in red) bottom left of the post you are replying to.

To insert an image, I would put it in my clipboard (so on Windows Ctrl-C), then in the compose window Ctrl-V and it inserts a temporary link. It will then quickly upload that image which will show when the post is “submitted”.

Good thing you were able to sort yourself out anyways. We are here if things get more complicated for you, so don’t hesitate. But if posting examples please do follow the guidelines. We find most of the issues solving people’s problems is getting the initial examples right.

Terry

@freshenstein said in Delete everything after the twelth character in a line with other lines of text that need to be left alone:

Is there a way to add to this code that tells it to only look for lines that start with “thing”+number and then delete everything after 12 characters?

Possibly as long as the number is a consistent length, you would change your formula to something like ^(thing \d{6}). Doing it this way you need to limit to an exact character count, so the number must ALWAYS be 6 characters long.

Alternatively something like ^(thing \d+) will work. So it works up until the end of the number. This could be 12 characters, or more or less. The \d+ means as many digits that are together, but must be at least 1.

Terry

PS understand I’m only editing the first part of your regular expression. It’s up to you to add in the “rest of the line” or whatever else you intend to do.

@guy038
Thank you so much*It’s perfect :)

Hello, @alimirzaei5778, @neil-schipper, @terry-r, @alan-kilborn and All,

We can even speed up the search regex process with this syntax :

(?-is)^sunday.+\R.+\R(?:(?! 1112).+\R){4,}A=.+\R?

Indeed, if several consecutive blocks, without the string \x201112 at beginning of lines , it will select all these blocks, in one go !

You could say why does it work that way ? Well, the regex part (?:(?! 1112).+\R){4,} finds any consecutive range of lines which do not begin with \x201112

And it’s particularly the case of the lines :

Beginning with Sunday

Beginning with Int

Beginning with A=

Luckily, this accumulation of matched lines stops as soon at it meets a line beginning with \x201112. But, as it must also satisfy the end of the regex A=.+\R?, the regex engine is forced to backtrack 3 lines before ( by decreasing the quantifier of 3 ( one at a time ), in order to match the last line of the previous block, beginning with A= !

Best Regards,

guy038

@alan-kilborn Perfect. Thanks ever so much!

The response to the OP should have been “Center to what?”. The number of characters in a line in Notepad++ has practically a very high limit. As such there can be no concept of centering to a frame or a page.

If the OP meant to have the text centered when the file was printed, then that is something different, and probably a desirable feature to have even in a text editor.

Funny story. Shortly after I had released my GotoLineCol plugin, the first two issues I received were that the Column Position (either by Character or Byte) field in the plugin side panel had a limit of only 5-digits! See here: Issue #1, Issue #2.

I couldn’t have anticipated that people were dealing with files having lines longer than 99,999 characters. To resolve the issues, I increased the field length in the plugin panel to allow up to 8 digits. The fix took only a few minutes. But to test it, I had to prepare a file with at least a single line having more than 350,000 characters. This part took me significantly longer time.

@terry-r This was very helpful, and worked perfectly. I was able to use and also modify your solution to remove the ending time aswell. Really cool the stuff you can do with N++

@zarate-petery

As a starting point, this regex matches all complete lines that do contain PACKS_1: ^.*?PACKS_1.*?$\R

You can use it in a Replace All operation with Replace field completely empty; this would delete all these lines.

This would meet the overall need with your sample data, but possibly not all of your real world data.

@alan-kilborn no problem :)

i applied a brute force approach and now i hope my xml will work:

step 1) find <relationship and replace with <relationship>FYY ( *
step 2) find source and replace with ) source *
Step 3) find (?-s)(?-i:<relationship>|(?!\A)\G).?\K(?:\x20(.+?)) with identifier=“id-999999”
Step 4) find >FYY and replace with " "
Step 5) find <connection and replace with <connection>FYY
Step 6) find relationshipRef and replace with ( relationshipRef
Step 7) find (?-s)(?-i:<connection>|(?!\A)\G).?\K(?:\x20(.+?)) and replace with relationshipRef=“id-999999”
Step 8) find >FYY and replace with " "
Step 9) find ) source and replace with source

am i mad? :D

@neil-schipper
Thank you very much! That worked wonderfully!

Hello, @diz-hydron and All,

Well, @diz-hydron, I suppose you could begin with this very simple script, named diz.py

def player_1(m): return str(int(m.group(1)) + X1) + ', ' + str(int(m.group(2)) + Y1) def player_2(m): return str(int(m.group(1)) + X2) + ', ' + str(int(m.group(2)) + Y2) editor.rereplace('"player1": \\[\K(-?[0-9]+), (-?[0-9]+)', player_1); editor.rereplace('"player2": \\[\K(-?[0-9]+), (-?[0-9]+)', player_2);

Before running the script, of course, change the X1, Y1, X2 and Y2 values for true positive or negative integers ( e.g. +7 or -3 )

It should work nicely with your text posted here

In a next step, it would be better to enter the different values with, for instance, the notepad.prompt python command and assign the 4 typed numbers to the X1, X1, X2 and Y2 variables…

Best Regards,

guy038

@dave-venus ,

If you mean “When I double-click a .txt file, it opens with Notepad++ instead of MS Notepad”, then that does automatically happen when you install Notepad++. To undo it, use your Windows Operating System’s method of changing your file association – probably easiest is to right click on the .txt file, Open With, choose MS Notepad, and check “always open this type” or however it’s phrased in your exact version of Windows. (Note, these instructions aren’t unique to Notepad++ – any time you install a new file editor, it almost always changes the default association for one or more types of files, and if you don’t want that behavior, Open With is the way to re-associate it with your previous application.)

However, if, like @Lycan-Thrope assumed, you try to run notepad.exe directly (double-click on the executable, or use the Windows Run dialog and type notepad.exe) and it instead runs Notepad++, then you have done something odd at some point: probably, either you intentionally used the notepad replacement instructions – in which case you need to undo those – or you installed the “NotepadStarterPlugin”, in which case you need to follow the “Uninstallation” instructions on that plugin’s page.

@yuliya-drimmer I don’t think a general solution where you specify the number of after-lines is possible.

As you may know, a regex that matches a word and then removes line separators for a specific number of after-lines is possible. Hence, if the range of required after-lines is not too big, a family of regexes that supports the overall need could be made.

@yosef-ymj Hi. I suggest you learn to use Edit -> Column Editor (Alt+c) to insert a column of ascending numbers.

Then, learn to use Alt+MouseMovement to select rectangles, and gain skill with rectangular cut/copy/paste operations.

When working with rectangles, these are also helpful:

Shift+Alt+ArrowKey to adjust dimension Shift+Alt+LeftMouseClick to specify opposite corner of a rectangle whose other corner is current caret position

If your data is as uniform as shown, a sequence using the above operations will do what you want, although you may need to handle 1, 2 and 3 digit sections separately.

To review some creative solutions to rectangular text problems, use the magnifier icon and search this site for terms like “column editor rectangle paste”.

Drop a follow-up comment to indicate whether you succeeded.

@pete-wright ,

Not currently.

FAQ: How to make a feature request

@kracovwolf I think you will want to use “Search Replace” with “Search Mode” of “Regular Expression”.

This is a very complicated option, but what you specifically need to do is simple:

^J
means “J at the start of a line” in Regular Expression language. You can replace this with nothing. From your example, you should replace “J space” which is also there.

It will not remove the start of line. It will only remove J or remove J space.

J$
means “J at the end of a line”.

Doing one and then the other is simplest.

It will still be your responsibility to not remove more J s than you want to.

@martin-olsson This is a possible candidate for using a third-party “macro” program to create specific behaviour on your computer. I use a downloaded tool called “AutoHotkey” but I haven’t created with it recently.

As far as I remember, things that an AutoHotkey macro can do include:
Read the title bar of a program
Bring a program (Notepad++) to foreground and out of being minimized
Send a keystroke to a program (Ctrl N new document)

So you could have an icon on your screen that does all of that from one click.

Other options are possible, such as always waiting for YOU to foreground Notepad++ and THEN send Ctrl N each time, or, to see if the title bar says “new” for a newly created document already.

Or it could just make your middle mouse button send Ctrl N.

@by-eck I’m late to this, but I wonder if Notepad++ is the right tool for this job. If you have to do it more than once - a simple automatic text editor like “sed” would be more suitable.

It also resembles work I’ve had to do to copy database data to a format that pastes into Microsoft Excel out of “SQL Server Management Studio”. In that case, I wrote a fairly simple SQL user-defined function, whose output is what I want Excel to receive, starting with changing ‘01’ to =“01” so that Excel displays 01 instead of the number 1 - but also removing in-data line breaks and tabs and anything else that annoyed me. Oh, I think it fixes dates. So the output of the data process didn’t contain those hiccups.

I did that as paid work so I guess my employer owns it, but they may agree to sharing it with the world. Would you like me to ask?