emeditor

In EmEditor, what expression to use to filter for rows containing mismatching number of specified characters across two columns


If column 1 contains one specified character, e.g., “(“ and column 2 contains two of these characters, which expression to use to filter for these rows. The specified character could be any other character. See attached image as an illustration of the question.enter image description here


Solution

  • You can use JavaScript replacement expressions in the Replace dialog of EmEditor.

    1. Click the third empty column heading to select the whole third column.

    2. Press Ctrl+H to display the Replace dialog box.

    3. Click the Advanced... button to display the Advanced dialog box. Click Reset and OK. This step ensures the advanced options are set as default.

    4. In the Replace dialog box, Enter:

    1. Make sure the Regular Expressions and In the Selection Only options are set.

    2. Click Replace All.