Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #22158

    spiros
    Participant

    I have a tab file with 3 columns and I want to join column 2 with 3 and replace the tab between them with : (that is the “:” character and space). I do not see an option to add such a character in the Join dialog.

    #22165

    Yutaka Emura
    Keymaster

    Hello,

    You can disable Cell Selection Mode (but still keep the CSV (Tab Separated) mode), select column 2 and 3 by (double-)clicking the header or ruler, and then replace TAB with ‘:’ while In the Selection Only option is selected.

    Thanks,

    #22167

    spiros
    Participant

    Thank you.

    #22214

    spiros
    Participant

    When I tested with a 50.000 line document, it took a lot of time and when it was done, it froze. v17.1.0 beta 2

    I tried this instead which worked in an instant:

    (^.*)(\t)
    \1:

Viewing 4 posts - 1 through 4 (of 4 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