I am using an if activity to run a test on an excel table. The code I am using is: Row(“Expense Type”).ToString = “Hotel” And Row(“City/Location”).ToString = “Boston” And Convert.ToInt32(regex.Replace(“ExpenseAmount(rpt)”,"[,]","").ToString) >Boston
The Boston variable at the end has been declared as 300. I also show that System.Text.RegularExpressions has been imported so I can use Regex. I’m not sure why this is not working. Any ideas?