The result didn't agree with the condition

[ROBERT_RUSSELL_MONSA (ROBERT RUSSELL MONSALUD)]

In this scenario, the sequence determines and counts if there is a word “Absent” in the column. However, in the given column there is a word “Absent” but the output is still zero. How can I solve this? Has it something to do with the data types of the variables?

[vishal.kp (vishal)]

can you show the regex which you are matching

[ROBERT_RUSSELL_MONSA (ROBERT RUSSELL MONSALUD)]

System.Text.RegularExpressions.Regex.Matches(AttenString,“Absent” ).Count

[vishal.kp (vishal)]

Are you converting the whole column into string?

[ROBERT_RUSSELL_MONSA (ROBERT RUSSELL MONSALUD)]

I want to count the number of absences in the column.

[vishal.kp (vishal)]

Try this by giving your column name and the string which you want to search

[ROBERT_RUSSELL_MONSA (ROBERT RUSSELL MONSALUD)]

Thank you so much and I will work on it.

[vishal.kp (vishal)]