joining two columns but adding separator between them

[spiros]

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.

[Yutaka Emura]

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,

[spiros]

Thank you.

[spiros]

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:

[Author]

Posts