That's perfectly doable! This ought to work: search for
and replace with
It looks for any sequence of any number of not-a-tab, followed by a tab, all in a group of 6, and followed by yet another sequence of not-a-tab characters, and then one final tab that's going to be the little piggy that's not going to the market today.
you are te greatest!
so [^\t] means any character, not tab?
That is correct.
[...] defines a character set -- any single character or character code in it is valid, as a single character. The canonical example is "h[auo]t", which matches "hat", "hot", and "hut" but not "hit", "het", or "haut".
In normal use the character '^' is the code for "start of paragraph", but it looses this magical property inside a [...] set -- most other special codes do. When used as the very first code inside the character set definition it reverses the regular meaning.
Thus, "h[^auo]t" will match "hit" and "het", as well as "hAt", "h?t", "hät", "h䰫t" -- etc.; really anything except the three in the example above.
In your case, I used "[^\t]+" as a fast way to indicate "everything in between tabs".
now I get it...
I absorbe this into my brain...
in one click now my 5331 names are divided in 7 columns (don't ask why ) and thats what I wanted!