Community
    • Login

    Select data between tabs

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    6 Posts 4 Posters 767 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.
    • John CurreyJ
      John Currey
      last edited by

      Hi, I have a tab-delimited file. I’m writing a macro, and I’d like to select data between 2 tabs, and copy it to the clipboard. I can get to the correct spot, but can’t figure out how to select the data that is between the 2 tabs so I can copy it.

      Thanks.

      1 Reply Last reply Reply Quote 0
      • Terry RT
        Terry R
        last edited by

        @John-Currey said in Select data between tabs:

        how to select the data that is between the 2 tabs so I can copy it.

        Well, a regex (regular expression) would do it. Of course without knowing much of the sample data I can only work with the little you have stated.

        So using the “Find” function, and set search mode to regular expression.
        Find What:(?-s).+?\t
        Then use the “Find Next” button. See if that can be incorporated into your macro. This regex will also include the next tab, I was unsure whether you did want that or not.

        Terry

        1 Reply Last reply Reply Quote 3
        • Terry RT
          Terry R
          last edited by

          @Terry-R said in Select data between tabs:

          This regex will also include the next tab,

          Another better one which does NOT include the next tab is [^\t]+

          Terry

          1 Reply Last reply Reply Quote 4
          • John CurreyJ
            John Currey
            last edited by

            Terry,

            Thank you, that is exactly what I needed!

            1 Reply Last reply Reply Quote 1
            • Vasile CarausV
              Vasile Caraus
              last edited by

              @John-Currey said in Select data between tabs:

              select data between 2 tabs

              Can anyone tell more precisely, what it means “select data between 2 tabs” ?
              An example will be perfect, as to understand much easier.

              PeterJonesP 1 Reply Last reply Reply Quote 0
              • PeterJonesP
                PeterJones @Vasile Caraus
                last edited by

                @Vasile-Caraus ,

                The OP’s data has a TAB character (\t or \x09) followed by some data followed by a TAB character, and wants to select the data that comes between two
                490bb2c0-2678-4ac6-831e-4bcc3a6a1dd7-image.png

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