Reply To: Grep or scripting

#52675

From beginning of line to first tab, with 22 characters or more of non-tabs, replacing that tab with a soft return:

Find

^([^]{22,})

Replace

$1

(although you might want to add the tab again in the replacement line, so your next data is aligned the same as non-soft-returned lines).

It won't work perfectly; if there is a single name with lots of i's and no m's, it will broken while not necessary; and if you have a single long name with lots of m's, you'll need to spot those by eye. But I think these stand out of the crowd, and in any case there shouldn't be much of these (if there are too much remaining, decrease the number of minimal characters).

This article was last modified on December 7, 2014

Comments (0)

Loading comments...