Select data between tabs

[John Currey]

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.

[Terry R]

@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

[Terry R]

@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

[John Currey]

Terry,

Thank you, that is exactly what I needed!

[Vasile Caraus]

@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]

@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