Count
  • 04 May 2021
  • 1 Minute to read
  • Dark
    Light
  • PDF

Count

  • Dark
    Light
  • PDF

Count Matches

Allows you to count occurrences of a Text or Pattern.

  1. Select the appropriate Column(s)
  2. Select either ‘Text or Pattern’ or by ‘Delimiter’.
  3. Input a new Column Name where results are to be displayed.
  4. Input the Text or Pattern that needs to be counted.

Here are a few examples:

  1. Text or Pattern :
    Using Number 9.
Mobile Number MobileNumber_Count
9879877654 2
9844877654 1
987937654 2
9873377654 1
  1. By Delimiter
    Start Delimiter : T
    End Delimiter: 1
Id Id_Count
TL001 1
TL002 0
TL003 0
TL011 1

What's Next