Community
    • Login

    Delete every line below a bookmarked line.

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    47 Posts 6 Posters 2.3k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Antheds KennelA
      Antheds Kennel @datatraveller1
      last edited by

      @datatraveller1 Thanks, but unfortunately I can’t, because some rows have more rows that I want to save. Sorry I missed that in my request. Thanks, Thore

      1 Reply Last reply Reply Quote 1
      • Antheds KennelA
        Antheds Kennel @guy038
        last edited by

        @guy038 YES, this solved it. THANK YOU SO MUCH for the help. I’ll just run the large file of about 200,000 lines and see if it works there too. Have a good time, Thore.

        1 Reply Last reply Reply Quote 1
        • Antheds KennelA
          Antheds Kennel
          last edited by

          Unfortunately my friends, none of your ideas worked. They either delete ALL lines without # or delete the other lines that I wanted to keep. I have to take responsibility for this mistake as I have realized that I was unclear in my request. When I have bookmarked the lines I want to delete, for example if I want to keep the lines with odd numbers in my example, I will delete the line below them. Hope you are with me now as I have a terrible time conveying my thoughts.

          1 Reply Last reply Reply Quote 0
          • guy038G
            guy038
            last edited by guy038

            Hi, @antheds-kennel, @datatraveller1, @dr-ramaanand and All,

            OK… So, let’s suppose that your INPUT text is :

            Line 1
            Line 2
            Line 3
            Line 4
            Line 5
            Line 6
            Line 7
            Line 8
            ...
            

            You would like this OUTPUT, wouldn’t you ?

            Line 1
            Line 3
            Line 5
            Line 7
            ...
            

            If this correct, use the method that I gave in the first part of my previous post, regarding the search/replacement and, simply, change the FIND and REPLACE zones by :

            FIND (?-s)^(.+\R).+\R?

            REPLACE $1

            Do not forget to tick the Wrap around option and to select the Regular expression search mode !

            BR

            guy038

            dr ramaanandD 1 Reply Last reply Reply Quote 0
            • dr ramaanandD
              dr ramaanand @guy038
              last edited by dr ramaanand

              @Antheds-Kennel Please post both your exact input and output, then we can give you a perfect regular expression to get what you want. Please don’t forget to use the </> button (you can see that above the box that you type in, on the line that begins with “B I H …” and so on) to mark example text as “code” so that characters don’t get changed by the forum

              dr ramaanandD 1 Reply Last reply Reply Quote 0
              • dr ramaanandD
                dr ramaanand @dr ramaanand
                last edited by dr ramaanand

                @Antheds-Kennel My guess right now is to use (#STNEW:_TEST-\d+.*?)\R? in the Find field with $1 in the Replace field with the Regular expression mode ticked/selected. That will get rid of the line just below the line beginning with #STNEW:_TEST- but you must let us know what other lines there are in your original file which you want to keep (or else they will also get deleted)

                dr ramaanandD 1 Reply Last reply Reply Quote 0
                • dr ramaanandD
                  dr ramaanand @dr ramaanand
                  last edited by dr ramaanand

                  @Antheds-Kennel To find just just one line after the #STNEW:_TEST- string, type #STNEW:_TEST-\d+\R\K(?:.*.*) in the Find field and then leave the Replace field blank, tick/select the Regular expression mode and hit Replace All or Replace in files if you want to do this in multiple files to get rid of it (that will get rid of only one line, just below the line beginning with #STNEW:_TEST-)

                  dr ramaanandD 2 Replies Last reply Reply Quote 0
                  • Antheds KennelA
                    Antheds Kennel
                    last edited by Antheds Kennel

                    @guy038 said in Delete every line below a bookmarked line.:

                    $1

                    Hello again, I have uploaded a picture showing before and after with the code you gave first.
                    https://ibb.co/W51vDPT

                    PeterJonesP 2 Replies Last reply Reply Quote 0
                    • guy038G
                      guy038
                      last edited by guy038

                      Hello, @antheds-kennel ,

                      Globally, my regex S/R simply keep all the odd lines et delete all the even lines !

                      But, looking at your picture, I’m wondering :

                      May be, you want to delete the lines 2, 6 and 10, only ? So, each line which is right after a bookmarked line, throughout the end of file ?

                      BR

                      guy038

                      Antheds KennelA 1 Reply Last reply Reply Quote 0
                      • PeterJonesP
                        PeterJones @Antheds Kennel
                        last edited by

                        @Antheds-Kennel said in Delete every line below a bookmarked line.:

                        Hello again, I have uploaded a picture showing before and after with the code you gave first

                        You can just paste pictures into your reply, so they are embedded without people having to click a link to an external site.

                        And with some external sites, you can use the ![](...) syntax to embed the external image itself, rather than linking to their advertisement-ridden landing page
                        Using the code ![](https://i.ibb.co/zxwV87k/33.jpg) will embed your external image:

                        But since external sites can change their rules (thousands of imgur-hosted external images will no longer show in the forum, even though they used to work here, so much of our discussion history now has broken images because of the external site outside of our control), so it’s really best to just paste your image directly in your post.

                        Antheds KennelA 1 Reply Last reply Reply Quote 1
                        • dr ramaanandD
                          dr ramaanand @dr ramaanand
                          last edited by dr ramaanand

                          @dr-ramaanand said in Delete every line below a bookmarked line.:

                          #STNEW:_TEST-\d+\R\K(?:..)

                          @Antheds-Kennel The above Regular expression will help find it. Type #STNEW:_TEST-\d+\R\K(?:.*.*) in the Find field and then leave the Replace field blank, tick/select the Regular expression mode and hit Replace All or Replace in files if you want to do this in multiple files to get rid of it (that will get rid of only one line, just below the line beginning with #STNEW:_TEST-)

                          1 Reply Last reply Reply Quote 0
                          • PeterJonesP
                            PeterJones @Antheds Kennel
                            last edited by PeterJones

                            @Antheds-Kennel ,

                            After looking at your image, it is showing that the regex deletes all the lines after #STNEW: lines, and it seems you might be trying to say “but I only wanted it to delete the ones after a bookmark, so lines 2, 6, and 10 only, without also deleting 4, 8, 12, and 14”? Because if so, that is something you cannot do only with regex, because the regex engine cannot see your bookmarks. You CANNOT bookmark lines 1, 5, and 9, and then say “delete the lines right after a bookmark”.

                            The easiest thing to do would be to bookmark the lines you actually want to delete, rather than the line before the one you want to delete, and then use Search > Bookmark > Remove Bookmarked Lines. Or, simpler, if you’re using the Mark dialog to bookmark the lines to begin with (as you show in your screenshot), then just do a search/replace regex to do the search-and-delete in one step: Something like FIND = #STNEW:_TEST-(1|3|5)\R(.*\R) REPLACE = $2

                            –
                            Update: that was the wrong results; FIND = (#STNEW:_TEST-(?:1|3|5)\R)(.*\R) REPLACE = $1 is, I think, what I meant (untested, as I away from NPP)

                            Antheds KennelA 1 Reply Last reply Reply Quote 0
                            • guy038G
                              guy038
                              last edited by guy038

                              Hi, @antheds-kennel, @datatraveller1, @dr-ramaanand, @peterjones and All,

                              Peter, you said :

                              … Because if so, that is something you cannot do only with regex, because the regex engine cannot see your bookmarks. You CANNOT bookmark lines 1, 5, and 9, and then say “delete the lines right after a bookmark”.

                              I agree with this statement ! Regexes and bookmarks are different features ! However, as the OP bookmarked the lines ending with digits 1|3|5, we can imagine this regex S/R :

                              FIND ([135]\R).+\R

                              REPLACE $1

                              As expected, it would delete the lines 2, 6 and 10, only, leaving all the other lines unchanged !

                              Best Regards

                              guy038

                              1 Reply Last reply Reply Quote 0
                              • dr ramaanandD
                                dr ramaanand @dr ramaanand
                                last edited by dr ramaanand

                                Yes, that works, unless thr OP wants to delete other lines or skip deleting other lines. See https://regex101.com/r/EjNI9Y/1

                                1 Reply Last reply Reply Quote 0
                                • guy038G
                                  guy038
                                  last edited by

                                  Hi, @peterjones and All,

                                  Sorry, Peter,I should have read your post thoroughly, as you already provided a similar solution to mine : FIND (#STNEW:_TEST-(?:1|3|5)\R)(.*\R) and REPLACE = $1

                                  BR

                                  guy038

                                  1 Reply Last reply Reply Quote 0
                                  • Antheds KennelA
                                    Antheds Kennel @guy038
                                    last edited by Antheds Kennel

                                    @guy038 Hello and goodmorning from Sweden, I reached out to Ai this morning to see if it could help you understand what I mean. And I got this answer: "Delete Only the Lines Below Bookmarked Lines
                                    Step 1: Bookmark the Correct Lines
                                    Ensure you’ve bookmarked only the lines directly above the lines you want to delete. Use Ctrl+F2 to toggle bookmarks on or off for the relevant lines.
                                    Step 2: Verify Bookmarks
                                    Go to Search → Bookmarks → Show All Bookmarks to confirm that only the correct lines are bookmarked.
                                    Follow these steps precisely:

                                    Go to Macro → Start Recording.
                                    Perform these actions in sequence:
                                    Press Ctrl+F2 to jump to the next bookmark.
                                    Press the Down Arrow key to move the cursor to the line below.
                                    Press Ctrl+L to delete the line below.
                                    Press Ctrl+F2 again to jump to the next bookmark.
                                    Stop the recording via Macro → Stop Recording.
                                    Save the macro via Macro → Save Current Recorded Macro.
                                    Step 4: Run the Macro Until All Bookmarks Are Processed
                                    Go to Macro → Run a Macro Multiple Times.
                                    Select Run until the end of the file to ensure all lines below the bookmarked lines are deleted.
                                    If This Still Doesn’t Work
                                    If the macro doesn’t behave as expected, we could use a manual method involving regex. Bookmarks in Notepad++ can’t be directly accessed by regex, but they can act as visual markers while you use regex for other patterns.

                                    Deleting lines below bookmarked lines in Notepad++ cannot do by regex: Alternative alternate outlines flex recommendations use text off regular ACL–"

                                    Sorry for all the mistakes I make. I accept all the tips and corrections you give me. So I do what I can to correct my posts so that they don’t become wrong again. Kind regards Thore

                                    1 Reply Last reply Reply Quote 0
                                    • Antheds KennelA
                                      Antheds Kennel @PeterJones
                                      last edited by

                                      @PeterJones said in Delete every line below a bookmarked line.:

                                      @Antheds-Kennel said in Delete every line below a bookmarked line.:

                                      Hello again, I have uploaded a picture showing before and after with the code you gave first

                                      You can just paste pictures into your reply, so they are embedded without people having to click a link to an external site.

                                      And with some external sites, you can use the ![](...) syntax to embed the external image itself, rather than linking to their advertisement-ridden landing page
                                      Using the code ![](https://i.ibb.co/zxwV87k/33.jpg) will embed your external image:

                                      But since external sites can change their rules (thousands of imgur-hosted external images will no longer show in the forum, even though they used to work here, so much of our discussion history now has broken images because of the external site outside of our control), so it’s really best to just paste your image directly in your post.

                                      Ok, i will do that next time, or should i correct that one i already have posted?

                                      1 Reply Last reply Reply Quote 0
                                      • Antheds KennelA
                                        Antheds Kennel @PeterJones
                                        last edited by

                                        @PeterJones It’s true that I only want to delete the lines below the ones that are bookmarked. So technically I could blureed out the “#STNEW” lines since my original question was to delete all lines below the ones that are bookmarked. So I admit I was unclear.

                                        1 Reply Last reply Reply Quote 0
                                        • guy038G
                                          guy038
                                          last edited by guy038

                                          Hi, @antheds-kennel, @datatraveller1, @dr-ramaanand, @peterjones and All,

                                          Sorry, @antheds-kennel, But I still do not understand your goal ! You said :

                                          I only want to delete the lines below the ones that are bookmarked.

                                          Do you mean :

                                          I only want to delete each SINGLE line which is below the bookmarked lines

                                          or

                                          I only want to delete all the lines which are below the bookmarked lines


                                          In addition, in the description of your macro, you said, twice :

                                          Press Ctrl+F2 to jump to the next bookmark.

                                          This is not right ! This feature does not enable you to move to the next bookmark ! The Ctrl + F2 feature TOGGLE the Bookmark status of the current line :

                                          • If the current line is not bookmarked, a Ctrl + F2 action will bookmark this line

                                          • If the current line is bookmarked, a Ctrl + F2 action will un-bookmark this line


                                          To move to a bookmark, you can, either :

                                          • Hit the F2 key, which moves to the next bookmark

                                          • Hit the Shift + F2 combination, which moves to the previous bookmark

                                          BR

                                          guy038

                                          Antheds KennelA 3 Replies Last reply Reply Quote 0
                                          • Antheds KennelA
                                            Antheds Kennel @guy038
                                            last edited by

                                            @guy038 said in Delete every line below a bookmarked line.:

                                            I only want to delete all the lines which are below the bookmarked lines

                                            That is what i want, Sorry for not being clear enough, english is not my first language, but i will do my best.

                                            1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post
                                            The Community of users of the Notepad++ text editor.
                                            Powered by NodeBB | Contributors