How can I only extract numbers from a textfile in win forms?

Question

This is what my text file looks like (example)

28:Toy
1:Chocolate bar
10:Water bottle

I want it to only extract the numbers, then add the numbers together and put it into a label or something I've tried

foreach(int number in "money.txt"){
    int sum = number + number;
    label5.Text = sum.ToString();
}

But that doesn't seem to work.

Does this answer your question? [What's the fastest way to read a text file line-by-line?](https://stackoverflow.com/questions/8037070/whats-the-fastest-way-to-read-a-text-file-line-by-line) — Heretic Monkey, Dec 25 '19 at 18:41

Ukrainis · Answer 1 · 2019-12-25T20:07:10.800

0

var summ = 0;
var file = File.ReadAllLines("file.txt");
foreach (var line in file)
    {
        var number = int.Parse(line.Split(":")[0]);
        summ += number;
    }
    label5.Text = summ.ToString();

Something like this can be base, which you can use for your needs.

edited Dec 25 '19 at 20:07

answered Dec 25 '19 at 17:53

Ukrainis

534
2
16

Getting error "Cannot convert char to string" When I click on it, it brings me to the foreach keyword. – leonlejunchen Dec 25 '19 at 18:11
I created a simple app to try it. This code worked for me. Variable summ was the same, as the summ of numbers in file. – Ukrainis Dec 25 '19 at 20:08

score 0 · Answer 2 · edited Dec 25 '19 at 19:55

0

This is a simpler solution.

Read in the file
Parse the first element of the string (split with :)
Sum it up.

    var sumOfAllInts = File.ReadAllLines(textFile).ToList().Select(x => int.Parse(x.Split(':').First())).Sum();

edited Dec 25 '19 at 19:55

JohnyL

6,894
3
22
41

answered Dec 25 '19 at 18:14

Jawad

11,028
3
24
37

What would be the variable in this situation? - since I want to put it in a label. – leonlejunchen Dec 25 '19 at 18:18
@leonlejunchen Does this answer your question? please mark it answered if so. – Jawad Dec 30 '19 at 16:37

Nguyen Van Thanh · Accepted Answer · 2019-12-26T01:11:02.473

VERY IMPORTANT !

Your code:

foreach(int number in "money.txt"){
    int sum = number + number; // BIG ERROR
    label5.Text = sum.ToString();
}

You have make a big mistake with int sum = number + number;.

Take sum to out of your scope (maybe global) first.

You have to do 2 steps:

Try this online here

Step 1: Read content of your file:

using System.IO;

// Your code
static string yourTextFileContent = File.ReadAllText("money.txt");

Step 2: I wrote a method to do your work:

using System;
using System.Collections.Generic;
using System.Collections;
using System.IO;

public class Program
{
    // Demo string
    static string yourMoney = @"28:Toy
1:Chocolate bar
10:Water bottle";
    // Your real string
    //static string yourTextFileContent = File.ReadAllText("money.txt");
    public static void Main()
    {
        Console.WriteLine("Using IEnumerable");
        // int sum = 0;
        foreach (int item in GetEnumerableIntFromString(yourMoney))
        {
            sum += item;
            Console.WriteLine(item);
        }
        Console.WriteLine($"Sum: {sum}");
        //label5.Text = sum.ToString();
    }

    // Using IEnumerable
    private static IEnumerable<int> GetEnumerableIntFromString(string str)
    {
        string[] splitLine = str.Split(new[]{'\r','\n'},StringSplitOptions.RemoveEmptyEntries);
        foreach(string item in splitLine)
        {
            string[] splitToGetNumber = item.Split(new[]{':'},StringSplitOptions.RemoveEmptyEntries);
            yield return Convert.ToInt32(splitToGetNumber[0].Trim());
        }
    }
}

If you have an Enumerable, you want to Convert to List:

Enumerable<int> enumerable = yourEnumerable;
List<int> asList = enumerable.ToList();

Over complicating a simple task. – Jawad Dec 26 '19 at 03:25 — Jawad, Dec 26 '19 at 03:25

How can I only extract numbers from a textfile in win forms?

3 Answers3