microtom.net tom's windows tech blog

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
 
namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            string file = args[0];
            if (file == "")
            {
                Console.WriteLine("Please enter the path to the File!");
                Environment.Exit(1);
            }
            if (!File.Exists(file))
            {
                Console.WriteLine("Could not find File {0}!", file);
                Environment.Exit(1);
            }
 
            RemoveBlankRowsFromCSVFile(file, 0);
            RemoveBlankRowsFromCSVFile(file, CountLines(file));
        }
 
        public static void RemoveBlankRowsFromCSVFile(string filepath, int lastline)
        {
            if (filepath == null || filepath.Length == 0)
            {
                throw new ArgumentNullException("filepath");
            }
 
            if (!File.Exists(filepath))
            {
                throw new FileNotFoundException("Could not find file.", filepath);
            }
 
            String tempFile = Path.GetTempFileName();
            int linecount = 0;
 
            using (StreamReader reader = new StreamReader(filepath))
            using (StreamWriter writer = new StreamWriter(tempFile))
            {
                String line = null;
                while ((line = reader.ReadLine()) != null)
                {
                    linecount++;
 
                    line = line.Replace("\r\n", "").Replace("\n", "").Replace("\r", "");
                    if (!line.Equals(String.Empty))
                    {
                        if ((linecount >= lastline) && (lastline != 0))
                            writer.Write(line);
                        else
                            writer.WriteLine(line);
                    }
                }
 
            }
 
            File.Delete(filepath);
            File.Move(tempFile, filepath);
        }
 
        static int CountLines(string file)
        {
            int count = 0;
            using (StreamReader r = new StreamReader(file))
            {
                string line;
                while ((line = r.ReadLine()) != null)
                {
                    count++;
                }
            }
            return count;
        }
 
 
    }
}