Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #27841

    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

    Yutaka Emura

    You can use Replacement Expressions using JavaScript:

    For example,




    \J "\0".length;

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

    Please watch:

    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:

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