Databases
StackOverflow2013
Postsdbo
POc# counting identical strings from text file
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POc# counting identical strings from text file
    primarykey
    data
    text
    <p>I have a <code>foreach</code> statement where I go through several lines from a text file, where I have trimmed down and sorted out the lines I need. What I want to do is count up on how many times an identical string is present. How do I do this?</p> <p>Here is my code. It's the second <code>if</code> statement where I am stuck:</p> <pre><code> foreach (string line in lines.Where(l =&gt; l.Length &gt;= 5)) { string a = line.Remove(0, 11); if ((a.Contains(mobName) &amp;&amp; a.Contains("dies"))) { mobDeathCount++; } if (a.Contains(mobName) &amp;&amp; a.Contains("drops")) { string lastpart = a.Substring(a.LastIndexOf("drops")); string modifiedLastpart = lastpart.Remove(0, 6); } </code></pre> <p>Heres what some of the lines look like:</p> <p>a bag of coins</p> <p>a siog brandy</p> <p>a bag of coins</p> <p>a bag of coins</p> <p>the Cath Shield</p> <p>a tattered scroll</p> <p>So what im trying to do is counting up there are 3 lines with bag of coins. But i need to make it so that it can be everything, theres a drop lists thats huge. So cant add all of em, would take too long</p> <p>EDIT</p> <pre><code> private static void Main() { int mobDeathCount = 1; int lootCheckCount = 1; string[] lines = System.IO.File.ReadAllLines(@"C:\Users\Michael\Documents\Electronic Arts\Dark Age of Camelot\chat.log"); Console.WriteLine( "Enter which mob you want to see, remember to include the, for an example; The siog seeker, remember to start with a capital T"); string mobName = Console.ReadLine(); foreach (string line in lines.Where(l =&gt; l.Length &gt;= 5)) { string a = line.Remove(0, 11); if ((a.Contains(mobName) &amp;&amp; a.Contains("dies"))) { mobDeathCount++; } if (a.Contains(mobName) &amp;&amp; a.Contains("drops")) { string lastpart = a.Substring(a.LastIndexOf("drops")); string modifiedLastpart = lastpart.Remove(0, 6); var lineCountDict = modifiedLastpart.GroupBy(x =&gt; x).Where(x =&gt; x.Count() &gt; 1).ToDictionary(x =&gt; x.Key, x =&gt; x.Count()); foreach (var val in lineCountDict) { Console.WriteLine(val.Key + " - " + val.Value); } </code></pre> <p>new lines;</p> <p>[01:09:55] The siog seeker drops a bag of coins.</p> <p>[01:09:55] The siog seeker drops a siog brandy.</p> <p>[01:09:55] The siog seeker dies!</p> <p>[01:09:55] You get 3,687,564 experience points.(1,638,917 camp bonus)</p> <p>[01:10:31] You cast a Lesser Disenchanting Eruption spell!</p> <p>[01:10:31] You hit the siog seeker for 424 (+18) damage!</p> <p>[01:10:31] The siog seeker drops a bag of coins.</p> <p>[01:10:31] You pick up 18 silver and 88 copper pieces.</p> <p>[01:10:31] The siog seeker dies</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USWinkz
    1. USWinkz
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POc# counting identical strings from text file
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POc# counting identical strings from text file
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. POc# counting identical strings from text file
      1. USWinkz
      1. VTBountyStart
    1. CODo you mean how many times it's present in a _single line_?
      singulars
      1. POc# counting identical strings from text file
      1. USDonBoitnott
    2. COWhat is "stuck" in the 2nd statement? From the description, `mobDropCount++` would be sufficient - but I suspect you are interested in counting *what* dropped, no? For this, consider a [Dictionary<string,int>](http://msdn.microsoft.com/en-us/library/xfhwa508.aspx) where the name of the thing dropped is the key while the number of times is the value. Also search for "C# frequency map" or "C# histogram" on SO, as many approaches will use a Dictionary.
      singulars
      1. POc# counting identical strings from text file
      1. USuser2246674
    3. CONo I mean if there are 3 lines which are exactly the same, i can count them up. Hope im making my self clear enough :)
      singulars
      1. POc# counting identical strings from text file
      1. USWinkz
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload