tamadsijuan
Eternal Poster
- Joined
- Feb 17, 2016
- Posts
- 849
- Reaction
- 327
- Points
- 268
3 folders with CSV files
lahat ng folder papasukin and imerge yung mga csv files into 1 file(Merged.csv)
Question is nag eeror sya pag walang laman yung isang folder
new lang po kasi sa c# or programming
ang idea ko is gagamit ako ng if statment kaso hindi ko sure kung saan ko ilalagay at panung code(statement)yung ilalagay ko
error ko is : {"Sequence contains no elements"} sa may csvheader
salamat po sa mga makakatulong
lahat ng folder papasukin and imerge yung mga csv files into 1 file(Merged.csv)
Question is nag eeror sya pag walang laman yung isang folder
new lang po kasi sa c# or programming
ang idea ko is gagamit ako ng if statment kaso hindi ko sure kung saan ko ilalagay at panung code(statement)yung ilalagay ko
error ko is : {"Sequence contains no elements"} sa may csvheader
salamat po sa mga makakatulong
Code:
namespace Merge
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
Path paths = new Path();
/*paths.path1 = textBox1.Text + @"\";
paths.path2 = textBox2.Text + @"\";
paths.path3 = textBox3.Text + @"\";*/
var Allpaths = new List<string>() { paths.path1, paths.path2, paths.path3 };
foreach (string lcPaths in Allpaths)
{
string newPath = lcPaths + "merged.csv";
var all = Directory.GetFiles(lcPaths, "*.csv", SearchOption.TopDirectoryOnly);
string[] csvheader = { File.ReadAllLines(all.First()).First(l => !string.IsNullOrWhiteSpace(l)) };
var mergedata = all.SelectMany(csv => File.ReadAllLines(csv).SkipWhile(l => string.IsNullOrWhiteSpace(l)).Skip(0));
File.WriteAllLines(newPath, mergedata);
}
}
}
}