How to solve the problem of Regex.Matches ?

See more:

C#

.NET

regular-expression

Please see the following code:

List<string> ListOfGlobalTables = new List<string>();
string selectpart="SELECT Summary_New.ServiceName AS '[Q1].[ServiceName]'"


ListOfGlobalTables.Add("Summary");
ListOfGlobalTables.Add("Summary_New");

 foreach (string item in ListOfGlobalTables)
                {
                    string tableNamePlusDot = item + ".";

                    int count = Regex.Matches(selectpart, tableNamePlusDot).Count; 
                   
                  // just think what count should return
                  }

For the first item in the List, the following code return tableNamePlusDot as "Summary.".

string tableNamePlusDot = item + ".";

After that the count should return 0 for the following code

int count = Regex.Matches(selectpart, tableNamePlusDot).Count;

but it returns 1 !
Can anyone please help me to solve this problem ?