var newIssueList = Regex.Replace(@"Cube Engine/Strata.CubeEngine.UserDefinedFunctions 0 Jazz AP Service/Jazz AP Service 30 ModelCacheWebService/ModelCacheWebService 0 OData 0 Optimization/Strata.Optimization 0 Strata Administrator 4 Strata Cube Reporter/Strata.CubeReporter 0 Strata Spoon/Strata.Spoon 0 Strata Template Architect 0 Strata.Base 1 Strata.Base.Internal 0 Strata.CS.Base 2 Strata.CS.Jazz.ABB 252 Strata.CS.Jazz.Biz 331 Strata.CS.Jazz.Biz.CCI 49 Strata.CS.Jazz.Biz.DSS.APReimbursementEngine 0 Strata.CS.Jazz.Biz.DSS.Episodes 2 Strata.CS.Jazz.Biz.DSS.Episodes.EpisodeDefinition 1 Strata.CS.Jazz.Biz.DSS.Episodes.EpisodeVisualizer 3 Strata.CS.Jazz.Biz.DSS.HPAdmin 9 Strata.CS.Jazz.Biz.Notifications 0 Strata.CS.Jazz.Biz.Snapshot/Properties 0 Strata.CS.Jazz.Biz.StarterSet 43 Strata.CS.Jazz.Dimensionality 0 Strata.CS.Jazz.FP 0 Strata.CS.Jazz.Ideas 0 Strata.CS.Jazz.UI 3 Strata.DataStudio20/Strata.DataStudio20 0 Strata.Entity.Base 0 Strata.Hangfire.Service 0 Strata.Jazz.Biz 1 Strata.Jazz.FoolsGold.Biz 0 Strata.Jazz.Hangfire 1 Strata.Jazz.Hangfire.WebServices 0 Strata.Jazz.Midas.Biz 19 Strata.Jazz.Midas.Web 13 Strata.Jazz.MVC 0 Strata.Jazz.UI 0 Strata.Jazz.Web 207 Strata.Reporting.ExcelReporter40 0 Strata.Reporting.Opus 0 Strata.Score 2 Strata.Score.ConfigTool/Strata.Score.ConfigTool.Biz 0 Strata.Score.DimensionEditor 0 Strata.Score.DimensionEditor20 0 Strata.Score.DimensionEditor20.Biz 0 ", @"\r\n([\d]*\r\n)", "\t$1").Replace("\r\n", "\r").Split('\r') .Where(x => !string.IsNullOrEmpty(x)) .Select(x => new { project = x.Split('\t')[0], issues = x.Split('\t')[1] }) .Where(x => x.issues != "0"); newIssueList.Dump();