Delete duplicates in single column

[spiros]

Lets say I have a tab delimited file like this:

test[TAB]some text here
test[TAB]other text here
test[TAB]some other text here
try[TAB]some text here
try[TAB]other text here
try out[TAB]some text here
try out[TAB]other text here

I would like to delete the duplicate cells of the first column and move the text of their second column to the first instance of the match with a delimiter, I.e. #, so that it looks like this:

test[TAB]some text here#other text here#some other text here
try[TAB]some text here#other text here
try out[TAB]some text here#other text here

The matched words must be case sensitive.

[sky]

Step 1.
Find: (^.*)(\t.*)\n\1\t
Replace with: \1\2#

Step 2.
Click [Replace All] button

Step 3.
Repeat step 2 if need.

[spiros]

Thanks!

[Author]

Posts