Select data between tabs
-
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.
-
@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 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
-
Terry,
Thank you, that is exactly what I needed!
-
@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. -
The OP’s data has a TAB character (
\tor\x09) followed by some data followed by a TAB character, and wants to select the data that comes between two
