Write data to CSV file

Question

I'm having a question about writing data to a CSV file. I have a file named test.csv in which are 2 fields > accountnumber and relation ID. Now I want to add another field next to it: IBAN. The IBAN is the data from the first row which is validated by the SOAP function BBANtoIBAN.

How can I keep the 2 rows of data accountnumbers and relation IDs in the CSV and add the IBAN in the 3rd row?

This is my code so far:

using (var client = new WebService.BANBICSoapClient("IBANBICSoap"))
{
    List<List<string>> dataList = new List<List<string>>();
    TextFieldParser parser = new TextFieldParser(@"C:\CSV\test.csv");
    parser.TextFieldType = FieldType.Delimited;
    parser.SetDelimiters(";");
    while (!parser.EndOfData)
    {
        List<string> data = new List<string>();
        string row = parser.ReadLine();

        try
        {
            string resultIBAN = client.BBANtoIBAN(row);
            if (resultIBAN != string.Empty)
               data.Add(resultIBAN);
            else
               data.Add("Accountnumber is not correct.");
        }
        catch (Exception msg)
        {
            Console.WriteLine(msg);
        }
        dataList.Add(data);
    }  
}

How do you mean, in parser.Readline()? Is there any documentation or examples online so I can take a look at it? — Matheno
– Matheno, Commented Oct 10, 2013 at 7:09

progpow · Accepted Answer · 2013-10-10 07:40:37Z

2

I see it as:

StreamReader sr = new StreamReader(@"C:\CSV\test.csv")
StreamWriter sw = new StreamWriter(@"C:\CSV\testOut.csv")
while (sr.Peek() >= 0) 
{
    string line = sr.ReadLine(); 


try
{
       string[] rowsArray = line.Split(';');
       string row = rowsArray[0];
       string resultIBAN = client.BBANtoIBAN(row);
       if (resultIBAN != string.Empty)
       {
           line +=";"+ resultIBAN;
       }
       else
       {
            line +=";"+"Accountnumber is not correct.";
       }

 }
 catch (Exception msg)
 {
     Console.WriteLine(msg);
 }
 sw.WriteLine(line) 
 }
sr.Close();
sw.Close();

edited Oct 10, 2013 at 7:40

answered Oct 10, 2013 at 7:17

progpow

1,58013 silver badges27 bronze badges

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

9 Comments

Matheno Over a year ago

row is in this case line I guess?

Matheno Over a year ago

Hm, I'll add some additional info, I forgot some things

Matheno Over a year ago

The testOut.csv is created; but empty.

progpow Over a year ago

Are you add sr.Close() and sw.Close() ?

progpow Over a year ago

And it`s still empty? Have you message about exceptions?

|

John DeLeon · Accepted Answer · 2013-10-10 07:43:24Z

0

I would do something like this to parse the csv file, and add an extra item to the data list:

        List<List<string>> dataList = new List<List<string>>();
        string filename = @"C:\CSV\test.csv";
        using (StreamReader sr = new StreamReader(filename))
        {
            string fileContent = sr.ReadToEnd();

            foreach (string line in fileContent.Split(new string[] {Environment.NewLine},StringSplitOptions.RemoveEmptyEntries))
            {
                List<string> data = new List<string>();
                foreach (string field in line.Split(';'))
                {
                    data.Add(field);
                }
                try
                {
                    string resultIBAN = client.BBANtoIBAN(data[0]);
                    if (resultIBAN != string.Empty)
                    {
                        data.Add(resultIBAN);
                    }
                    else
                    {
                        data.Add("Accountnumber is not correct.");
                    }
                }
                catch (Exception msg)
                {
                    Console.WriteLine(msg);
                }
                dataList.Add(data);
            }

edited Oct 10, 2013 at 7:43

answered Oct 10, 2013 at 7:33

John DeLeon

3051 silver badge3 bronze badges

2 Comments

Matheno Over a year ago

Then 'row' in this case is 'field'? How can I validate the value of the first row into the function BBANtoIBAN and then add a 3rd row with the output of the function?

John DeLeon Over a year ago

Sorry, didn't catch that. You would pass in the first string in the List.

Collectives™ on Stack Overflow

Write data to CSV file

2 Answers 2

9 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related