Skip 1st line while reading from csv file.

Ms_ Dev

Hi Everyone,

I have the following code -

static void Main(string[] args)
{
Console.Clear();
string fileName = "\\file1.csv";
fileName = Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + fileName;
var fileStream = new FileStream(fileName, FileMode.Open, FileAccess.Read);
using (var streamReader = new StreamReader(fileStream, Encoding.UTF8))
{
string line,ID, UniqNumber;
while ((line = streamReader.ReadLine()) != null)
{
ID = line.Length >= 1 ? line.Substring(1,7) : string.Empty; UniqNumber = line.Length >= 1 ? line.Substring(8, 12) : string.Empty;
Console.WriteLine("ID={0},UniqNumber={1}", ID, UniqNumber);
}
}
Console.ReadKey();
}

I want to skip the first row while performing the operation. PLease help to omit the first line as it may contains invalid data.

Thanks,

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp10y ago
Accepted answer
Hi,
If you just need to ignore first line always, try like below -
streamReader.ReadLine();//Skips first line
string line,ID, UniqNumber;
while ((line = streamReader.ReadLine()) != null)
{
Midhun Tp10y ago
Hi,
I think that may work. However it is better if you try that yourself and make sure it works. You can also do the same inside your while loop if it works.
Ms_ Dev10y ago
@Midhun,
To skip first 3 lines, can i iterate it to the loop. like this -
for(inti=0;i<3;i++)
{
streamReader.ReadLine();
}
what are your suggestions ?
Salman Beg10y ago
Hi.
Please refer these links it might help you
http://stackoverflow.com/questions/18220241/how-to-ignore-the-first-line-in-a-csv-file-when-you-read-the-csv-file-in-c-sharp
http://stackoverflow.com/questions/5618740/how-to-skip-first-line-and-start-reading-file-from-second-line-in-c-sharp
Thanks.