Verifying and parsing csv to 2D array in C# Visual Studios

Question

Just trying out C# to make a button that loads csv files verify them and parse them:

protected void Upload_Btn_Click(object sender, EventArgs e)
{
    string test = PNLdataLoader.FileName;
    //checks if file is csv
    Regex regex = new Regex("*.csv");
    Match match = regex.Match(test);
    if (match.Success)
    {
        string CSVFileAsString = System.Text.Encoding.ASCII.GetString(PNLdataLoader.FileBytes);
        System.IO.MemoryStream MS = new System.IO.MemoryStream(PNLdataLoader.FileBytes);
        System.IO.StreamReader SR = new System.IO.StreamReader(MS);
        //Store each line in CSVlines array of strings
        string[] CSVLines = new string[0];
        while (!SR.EndOfStream)
        {
            System.Array.Resize(ref CSVLines, CSVLines.Length + 1);

            CSVLines[CSVLines.Length - 1] = SR.ReadLine();

        }
    }

So far I got it to store the lines in CSVLines but I am not sure what is wrong with the regex. Is there a more efficient way to do this?

@MarkF I did not get to that part yet still looking at the documentation on how to do it. — ccsv
– ccsv, Commented Apr 19, 2014 at 8:34

Community · Accepted Answer · 2017-05-23 12:11:13Z

0

That isn't a valid expression, its saying match whatever character that comes before * 0 or more times, since there is no character before that there is a problem.

This will probably match most things, it does not include special characters.

Regex regex = new Regex("[a-zA-Z0-9]{1,}.csv");

You could also do this instead:

if(test.EndsWith(".csv"))

and lastly, I would change your array to a List<T> or something like that, futher explained here: What is more efficient: List<T>.Add() or System.Array.Resize()?

//Store each line in CSVlines array of strings
List<string> CSVLines = new List<string>();
while (!SR.EndOfStream)
{
    CSVLines.Add(SR.ReadLine());

}

EDIT: List<T> is in System.Collections.Generic

edited May 23, 2017 at 12:11

CommunityBot

11 silver badge

answered Apr 19, 2014 at 6:59

Mark F

1767 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Verifying and parsing csv to 2D array in C# Visual Studios

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related