Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • October 3, 2021 at 6:21 am #27841
    spiros
    Participant

    Is there any way to create character count columns for tsv, for example as is done in Excel with =LEN(A1) and then copying it down? And then creating another an extra column that can run a calculation on the values of those, ie =A1/B1

    October 30, 2021 at 9:45 am #27874
    Yutaka Emura
    Keymaster

    You can use Replacement Expressions using JavaScript:

    For example,

    replacing

    .*

    with

    \J "\0".length;

    with the Regular Expressions option will replace the strings with their length.

    Please watch:

    https://youtu.be/xWUX37VHrTM

    for more information about Replacement Expressions using JavaScript.

    Alternatively, select the second or righter column, and replacing with

    \J cell( -1 ).length;

    will count the cell on the left.

    Also see: http://www.emeditor.org/en/howto_search_replacement_expression_syntax.html

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.