Tagged: 

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #22048

    spiros
    Participant

    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.

    #22049

    sky
    Participant

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

    Step 2.
    Click [Replace All] button

    Step 3.
    Repeat step 2 if need.

    #22050

    spiros
    Participant

    Thanks!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

Share with friends... Tweet about this on TwitterShare on FacebookShare on Google+Email this to someone