如何从CSV文件中删除所需的字符串 [英] how to delete required string from csv file
问题描述
大家都试图实现在某些csv文件中删除行;
文件的示例:
hi all try to realize deleting line in some csv file; example of file:
24 august 2013 г.,,14:00,00:00,;
24 august 2013 г.,,14:00,00:00,;
24 august 2013 г.,2342,14:00,00:00,23424;
24 august 2013 г.,2342,14:00,19:00,23424;
criteria - 24 august 2013 г.,2342
结果必须像
24 august 2013 г.,,14:00,00:00,;
24 august 2013 г.,,14:00,00:00,;
我的想法
打开文件-
my idea open file -
FileStream fs = new FileStream(filePath, FileMode.Open,
FileAccess.ReadWrite);
StreamReader sr = new StreamReader(fs);
将所有数据放入数组中
string lines = sr.ReadToEnd();
string []result = lines.Split(';');
比获取删除数据的条件(某些字符串)
than get criteria for deleting data (some string)
string criteria = dateTimePicker1.Text.ToString()+','
+eventNameDeleteTextBox.Text.ToString();
sr.Close();
在数组中搜索,
int startStr = lines.IndexOf(criteria);//find start position
int length = lines.IndexOf(';',startStr)-startStr;//find end position
删除
字符串dataRemoved = lines.Substring(startStr,length);
viewTextBox.Text = dataRemoved;
delete string dataRemoved = lines.Substring(startStr,length); viewTextBox.Text = dataRemoved;
并写入文件更新的数据
FileStream fs1 = new FileStream(filePath, FileMode.Open,
FileAccess.Write, FileShare.None);
StreamWriter sw = new StreamWriter(fs1);
sw.WriteLine(dataRemoved);
sw.Close();
但是它不能正常工作-它的复制字符串必须删除到文件的开头并删除所有;符号,哪里错了?
but it's work not correctly - it;s copy string that must be deleted to the start of the file and remove all ; symbols, where im wrong?
推荐答案
尝试类似的方法,如果您的文件很小,那么下面的解决方案应该不是问题。
Try something like this, If your file is small then below solution shouldn't be a problem.
string rawdata = @"24 august 2013 г.,,14:00,00:00,;
24 august 2013 г.,,14:00,00:00,;
24 august 2013 г.,2342,14:00,00:00,23424;
24 august 2013 г.,2342,14:00,19:00,23424;";//consider this is raw file
string[] lines = rawdata.Split(new string[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries);
List<string> result = new List<string>();
foreach (var line in lines)
{
if (!line.Contains("24 august 2013 г.,2342"))
{
result.Add(line);
}
}
现在您的预期结果将在结果
列表。您可以使用结果列表创建一个新文件。
now your expected result will be in result
List. You can create a new file with result List.
如果这不能回答您的问题,请提供更多信息。我会尝试提供更好的解决方案。
If this is not answering your question give more info. I'll try to give better solution.
这篇关于如何从CSV文件中删除所需的字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!