c#逐行解析文本数据

我认为你根本不需要Regex。你只需要绳子。按行和空格分隔。

string[] lines = data.Split(Enviroment.NewLine);

对于每一行，您可以通过空格分隔行来获得字段。

string[] fields = line.Split(' ');

EDIT: add Row variable as suggested by Ash:

鉴于您没有指定要将数据写入哪个对象，我假设它是一个名为Row的数据集:

private void Parsing_String(string filename)    
{
    DataTable dt = CreateDataTable();
    foreach (String str in File.ReadLines(filename))
    {
      String[] strCols = str.Split(Convert.ToChar(" "));
      DataRow Row = dt.NewRow(); //Where dt is a DataTable
      for (int i =0; i < strCols.length; i++)
      {
           Row[i] = strCols[i].Substring(2); //This will start reading from the third character
      }
      dt.Rows.Add(Row);
     }
      listView1.ItemsSource = dt.Rows;
}
//**EDIT**: Just in case you don't have a datatable and you want to create a small one:
public DataTable CreateDataTable()
    {
        DataTable dt = new DataTable();
        new string[] { "Column 1", "Column 2", "Column 3", "Column 4", "Column 5", "Column 6" }
            .ToList()
            .ForEach(c => { dt.Columns.Add(new DataColumn(c)); });
        return dt;
    }

EDIT: Last Try(忽略上面的代码):

    private void Parsing_String(string filename)
    {
        List<Row> list = new List<Row>();
        foreach (String str in File.ReadLines(filename))
        {
            String[] strCols = str.Split(Convert.ToChar(" "));
            list.Add(new Row() 
            {
                Column1 = strCols[0].Substring(2),
                Column2 = strCols[1].Substring(2),
                Column3 = strCols[2].Substring(2),
                Column4 = strCols[3].Substring(2),
                Column5 = strCols[4].Substring(2),
                Column6 = strCols[5].Substring(2)
            });
        }
        dg.ItemsSource = list;
    }
    public class Row
    {
        public string Column1 { get; set; }
        public string Column2 { get; set; }
        public string Column3 { get; set; }
        public string Column4 { get; set; }
        public string Column5 { get; set; }
        public string Column6 { get; set; }
    }

然后在你的xaml中:

如果你想指定自定义标题，你必须修改它，这样它就不会自动生成列，而是使用绑定，即:

   <DataGrid x:Name="dg" AutoGenerateColumns="False">
        <DataGrid.Columns>
            <DataGridTextColumn Binding="{Binding Column1}" Header="Column 1"></DataGridTextColumn>
            <DataGridTextColumn Binding="{Binding Column2}" Header="Column 2"></DataGridTextColumn>
            <DataGridTextColumn Binding="{Binding Column3}" Header="Column 3"></DataGridTextColumn>
            <DataGridTextColumn Binding="{Binding Column4}" Header="Column 4"></DataGridTextColumn>
            <DataGridTextColumn Binding="{Binding Column5}" Header="Column 5"></DataGridTextColumn>
            <DataGridTextColumn Binding="{Binding Column6}" Header="Column 6"></DataGridTextColumn>
        </DataGrid.Columns>
    </DataGrid>

Edit这将计算第一列总数

protected int CalculateFirstColumnTotal(List<Row> list)
{
    int total = 0;
    foreach (Row row in list)
      total += int.Parse(row.Column1);
}

编辑:

您从未实际调用Parsing_String方法，将以下行添加到browse方法中:

private void Browse_btn_Click(object sender, RoutedEventArgs e)    
{
    //Existing Code
    Parsing_String(textBox.Text);  //Add this line to the last line of the method.
}

可能是这样的:

var result = from row in theFileAsString.Split(''n')
             select new {
                Columns = row.Split(' ').Select(s => s.Substring(2))
             }

你会有一个IEnumerable，每个项目都有一个属性Columns，包含字符串的数据。

虽然没有经过测试，但是你明白了。

好吧，这可能有点过头了，但是您提到希望将数据放入listview(也许是数据网格?)，在这种情况下，您可能希望将数据放入某种对象形式。这取决于你得到这些数据后，你打算怎么处理它们。

假设一旦你得到了数据，你会想要操作它或对它做更多的事情，尝试这样做-你应该能够直接把它放入一个新的控制台应用程序并运行它。

namespace ConsoleApplication6
{
    using System;
    using System.Collections.Generic;
    using System.IO;
    using System.Text.RegularExpressions;
    class Program
    {
        static void Main(string[] args)
        {
            string filename = @"c:'test.txt";
            // Because you're working with a small file, we'll just read all the lines into memory
            List<LineData> processedLines = new List<LineData>();
            foreach (var line in File.ReadAllLines(filename))
            {
                processedLines.Add(new LineData(line));
            }
            // Write out the line data to the console to prove that it has been read
            foreach (var processedLine in processedLines)
            {
                Console.WriteLine(
                    "{0},{1},{2},{3},{4},{5}", 
                    processedLine.Column1, 
                    processedLine.Column2,
                    processedLine.Column3,
                    processedLine.Column4,
                    processedLine.Column5,
                    processedLine.Column6);
            }
        }
    }
    public class LineData
    {
        public LineData(string line)
        {
            // Regex basically means find two digits ("Prefix") followed by 3 digits ("Value")
            Regex regex = new Regex(@"(?<Prefix>'d{2})(?<Value>'d{3})");
            var lineMatches = regex.Matches(line);
            if (lineMatches.Count != 6)
            {
                // You should really be throwing your own exception type...
                throw new Exception("Expected 6 columns!");
            }
            this.Column1 = this.ExtractMatchData(lineMatches[0]);
            this.Column2 = this.ExtractMatchData(lineMatches[1]);
            this.Column3 = this.ExtractMatchData(lineMatches[2]);
            this.Column4 = this.ExtractMatchData(lineMatches[3]);
            this.Column5 = this.ExtractMatchData(lineMatches[4]);
            this.Column6 = this.ExtractMatchData(lineMatches[5]);
        }
        private string ExtractMatchData(Match match)
        {
            return match.Groups["Value"].Value;
        }
        public string Column1 { get; set; }
        public string Column2 { get; set; }
        public string Column3 { get; set; }
        public string Column4 { get; set; }
        public string Column5 { get; set; }
        public string Column6 { get; set; }
    }
}

using (var stream = File.Open(this.filename, FileMode.Open, FileAccess.Read)
{
    var reader = new StreamReader(stream);
    var data = reader.ReadLine();
    while (!String.IsNullOrWhitespace(data))
    {
        string[] columns = data.Split(' ');
        Console.WriteLine(string.Format("{0} {1} {2} {3} {4} {5}", columns[0], columns[1],));
        data = reader.ReadLine();
    }
}

你不需要使用正则表达式。

var data = @"10192 20351 30473 40499 50449 60234
10192 20207 30206 40203 50205 60226
10192 20252 30312 40376 50334 60252";
var result = from line in data.Split(new[] { "'r'n", "'n" }, StringSplitOptions.RemoveEmptyEntries)
             let splitted = line.Split(new[] {' '}, StringSplitOptions.RemoveEmptyEntries)
             select splitted.Select(s => s.Substring(2));

或文件

using System.IO; // In the top
var result = from line in File.ReadLines("path")
             let splitted = line.Split(new[] {' '}, StringSplitOptions.RemoveEmptyEntries)
             select splitted.Select(s => s.Substring(2));

result现在将包含字符串序列的序列(其中前两个字符被删除)。这个版本适用于Unix和Windows的换行符。它还删除了可能导致其他答案失败的额外空白。