Count
- 04 May 2021
- 1 Minute to read
- Print
- DarkLight
- PDF
Count
- Updated on 04 May 2021
- 1 Minute to read
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Count Matches
Allows you to count occurrences of a Text or Pattern.
- Select the appropriate Column(s)
- Select either ‘Text or Pattern’ or by ‘Delimiter’.
- Input a new Column Name where results are to be displayed.
- Input the Text or Pattern that needs to be counted.
Here are a few examples:
- Text or Pattern :
Using Number 9.
Mobile Number | MobileNumber_Count |
---|---|
9879877654 | 2 |
9844877654 | 1 |
987937654 | 2 |
9873377654 | 1 |
- By Delimiter
Start Delimiter : T
End Delimiter: 1
Id | Id_Count |
---|---|
TL001 | 1 |
TL002 | 0 |
TL003 | 0 |
TL011 | 1 |