Count occurrences

This processor counts the number of occurrences of a pattern in the specified column

Matching modes

  • ‘Complete value’ : counts complete cell values (output can only be 0 or 1)
  • ‘Substring’ : counts all occurrences of a string within the cell
  • ‘Regular expression’: counts matches of a regular expression

Normalization modes

  • Case-sensitive matches (‘Exact’ mode)
  • Case-insensitive matches (‘Lowercase’ mode)
  • Accents-insensitive matches (‘Normalize’ mode)

Note: accent-insensitive matching is only available for ‘complete value’ matching.