Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Select data between tabs

    Help wanted · · · – – – · · ·
    4
    6
    137
    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 Currey
      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 R
        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 R
          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 Currey
            John Currey last edited by

            Terry,

            Thank you, that is exactly what I needed!

            1 Reply Last reply Reply Quote 1
            • Vasile Caraus
              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.

              PeterJones 1 Reply Last reply Reply Quote 0
              • PeterJones
                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
                Copyright © 2014 NodeBB Forums | Contributors