writing data into csv file

Hesham Hassanein

I have read references for writing data into csv file but my problem is that i wan to read data from another 2 files and select two specific elements (one from each file and then write them into the new file). Here is what i came to

The file is not generated and I want to know how can i get the y as the element in the other csv line

This is reading two csv files and generating a new one but i want to select the x from the first csv file and y from the second csv file.

static void LeftBottom(int MobileID)
{
string ProgramPfad = (@"C:\Robotron\Execution\"+MobileID+".csv");
int b = 2;
string linee;
List x= new List();
List y = new List();

int z = 25;
StreamReader reader = File.OpenText(@"C:\Robotron\Execution\TS_Right_Bottom.csv");
StreamReader rdr = File.OpenText(@"C:\Robotron\Execution\TS_Left_Top.csv");
while ((linee = reader.ReadLine()) != null)
{
string[] fields = linee.Split('\t');
if (fields.Length != 15) continue;
int Keyid = Convert.ToInt32(fields[0]);
int id = Convert.ToInt32(fields[1]);
if (id == MobileID)
{
x.Add(fields[5]);
y.Add(fields[6]);
break;
}

using (System.IO.StreamWriter file = new System.IO.StreamWriter(ProgramPfad))
{
file.WriteLine("intMobileID;strTasten_Name;strTastenfunktion;strDruckrichtung;dblX_Wert;dblY_Wert;dblZ_Wert;dbldX_Wert;dbldY_Wert;dbldZ_Wert;intTastendruck;intDauer;intAnzahl;strBewegungstyp");
string[] buffer = new string[1];
buffer[b - 1] = (Keyid+";"+MobileID+";"+"TS_Left_Bottom"+";"+";"+"mitte"+";"+ x+";"+y +";"+z+";"+0+";"+0+";"+0+";"+12000+";"+100+";"+1+";"+"XY-Z");
}
}
}

26 Replies

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

Vulpes12y ago
Accepted answer
Well, Length and Width are Lists of doubles, not 'scalar' doubles.

You'll therefore need to use a loop to display them:

List Length = yList.Zip(y2, (first, second) => double.Parse(first) - double.Parse(second)).ToList();

List Width = xList.Zip(x2, (first, second) => double.Parse(first) - double.Parse(second)).ToList();

int len = Math.Min(Length.Count, Width.Count);
for (int i = 0; i < len; i++)
{
Console.WriteLine("The length and width of the display of the current Mobile are " + Length[i] + " ; "+ Width[i]);
}
Hesham Hassanein12y ago
So yes the double List made a difference but there is something that he cannot accept with the other Lists... but I cannot display them If i wrote Console.WriteLine(y2)... It will display this same message System.Collection.Generic.......
Hesham Hassanein12y ago
Look this is the method

static void GetLengthWidth(int MobileID)
        {

        //    List y1 = TopLeft(MobileID);   // get y values from Top Left

            StreamReader readerr = File.OpenText(@"C:\Robotron\Execution\TS_Left_Top.csv");
            string line3;
            List yList = new List();
            while ((line3 = readerr.ReadLine()) != null)
            {
                string[] fields = line3.Split(';');
                if (fields.Length != 15) continue;
                if (fields[1] == "intMobileID") continue;
                int id = Convert.ToInt32(fields[1]);
                if (id == MobileID)
                {

                    yList.Add(fields[6]);


                }
            }



            StreamReader rdrr = File.OpenText(@"C:\Robotron\Execution\TS_Right_Bottom.csv");
            string line4;
            List xList = new List();


            while ((line4 = rdrr.ReadLine()) != null)
            {
                string[] fields = line4.Split(';');
                if (fields.Length != 15) continue;
                if (fields[1] == "intMobileID") continue;
                int id = Convert.ToInt32(fields[1]);
                if (id == MobileID)
                {
                    xList.Add(fields[5]);


                }
            }

            List y2 = RightBottom(MobileID);
            List x2 = TopLeft(MobileID);

    //        List x1 = RightBottom(MobileID);    // get x values from Right Bottom
            List Length = yList.Zip(y2, (first, second) => double.Parse(first) - double.Parse(second)).ToList();

            List Width = xList.Zip(x2, (first, second) => double.Parse(first) - double.Parse(second)).ToList();
            Console.WriteLine("The length and width of the display of the current Mobile are" + Length + ";"+ Width);
            Console.ReadKey();
            readerr.Close();
            rdrr.Close();
        }

when i run the code it displays -------- ength and width of the display of the current Mobile are   - and then :   System.Collection.Generic. List 1 and thats it
Vulpes12y ago
Sounds like one (or more) of the number strings can't be parsed to an int.

So are there any numbers with decimal points?

If there are, use instead:

List Length = yList.Zip(y2, (first, second) => double.Parse(first) - double.Parse(second)).ToList();

If it still doesn't work, are any of the strings empty?
Hesham Hassanein12y ago
System.Format Exception
Hesham Hassanein12y ago
hey thanks for the reply... but it does not work... There is an exception...
Vulpes12y ago
OK, try:

List Length = yList.Zip(y2, (first, second) => first - second).ToList();

EDIT:

If yList and y2 are lists of strings rather than ints, then use instead:

List Length = yList.Zip(y2, (first, second) => int.Parse(first) - int.Parse(second)).ToList();
Hesham Hassanein12y ago
Number 2
Vulpes12y ago
Do you mean that you want to:

1.Subtract the sum of the elements in the y2 list from the sum of those in yList; or

2. Subtract corresponding elements of the y2 list from those in yList and place the results in another list; or

3. Treat the elements in the y2 list as successive digits in an integer, do the same with the elements of yList and then subtract the two integers?
Hesham Hassanein12y ago
ok i did it but i have problem with subtracting element from intList

I want to subtract the elements from a list

List Length = yList.ConvertAll(s => Int32.Parse(s)) - y2.ConvertAll(s => Int32.Parse(s));

i.e. 2 3 1 - 0 1 1 = 2 2 0

Is it possible using lists
Hesham Hassanein12y ago
It worked now... Thanks for your help.. I have another question.. :)

I have this method that returns the yList

static List RightBottom(int MobileID)
        {
            StreamReader reader = File.OpenText(@"C:\Robotron\Execution\TS_Right_Bottom.csv");
            string line4;
            List xList = new List();
            List yList = new List();
            List zList = new List();


            while ((line4 = reader.ReadLine()) != null)
            {
                string[] fields = line4.Split(';');
                if (fields.Length != 15) continue;
                if (fields[1] == "intMobileID") continue;
                int id = Convert.ToInt32(fields[1]);
                if (id == MobileID)
                {
                    xList.Add(fields[5]);
                    yList.Add(fields[6]);
                    zList.Add(fields[7]);

                }
            }

            reader.Close();


            if (xList.Count() > 0)
            {
                Console.WriteLine("The Corresponding Right Bottom Coordinates are: ");

                for (int i = 0; i < xList.Count; i++)
                {


                    Console.WriteLine(" {0} : {1} : {2}", xList[i], yList[i], zList[i]);

                }
            }
            else
                Console.WriteLine("There is no corresponding Information");
            Console.ReadKey();
            return yList;

what i need is to get the xList and call it in another method

This method is below

static void Get_Length_Width(int MobileID)
        {


            List x1 = RightBottom(MobileID);    // get x values from Right Bottom



        }
do you know how can i do so?.. I took alook at Tuples function that returns two values but i wanna call this value in another method...
Vulpes12y ago
Well, it looks like - for some reason - no values are being inserted into the list for one (or both) files as count can only be zero if at least one of the lists is empty.

One thing I've noticed that you're using a semi-colon for the field separator in one file but using a tab for the same purpose in the other file. Is this in fact correct?

Also are there definitely 15 fields per line in both files?
Hesham Hassanein12y ago
The count is always zero.

does this fill the values in x and y because the reason count is zero, I think because of x and y
List x = TopLeft(MobileID);
List y = new List();
y.Add(fields[6]);
Hesham Hassanein12y ago
No its not possible, if i enter mobile id 747... the two files have x and y values for the same ID
Vulpes12y ago
That would suggest that count == 0 which would only happen if the two lists didn't contain any 'x' or 'y' values because there were no matching lines (id == MobileID) in the files.

Is that a possibility?
Hesham Hassanein12y ago
Hey i really thank you for your help.

The csv file only has the first row written and nothing else

intMobileID;strTasten_Name;strTastenfunktion;strDruckrichtung;dblX_Wert;dblY_Wert;dblZ_Wert;dbldX_Wert;dbldY_Wert;dbldZ_Wert;intTastendruck;intDauer;intAnzahl;strBewegungstyp

I really appreciate your help. man
Vulpes12y ago
Yes, I think I know what you mean.

If you want to write multiple values to the file, then you'll need to use a loop.

There's also the question of what to do if you have more 'x' values than 'y' values, or vice versa.

For now, I've written the loop so that it only writes a line if there are both x and y values.

static void LeftBottom(int MobileID)
{
string ProgramPfad = (@"C:\Robotron\Execution\"+MobileID+".csv");
int b = 2;
string linee;
List x = RightBottom(MobileId);
List y = new List();

int z = 25;
StreamReader reader = File.OpenText(@"C:\Robotron\Execution\TS_Right_Bottom.csv");
while ((linee = reader.ReadLine()) != null)
{
string[] fields = linee.Split('\t');
if (fields.Length != 15) continue;
int Keyid = Convert.ToInt32(fields[0]);
int id = Convert.ToInt32(fields[1]);
if (id == MobileID)
{
y.Add(fields[6]);
//break; // remove this now
}
}
reader.Close();

int count = Math.Min(x.Count, y.Count);
string[] buffer = new string[count];

using (System.IO.StreamWriter file = new System.IO.StreamWriter(ProgramPfad))
{
file.WriteLine("intMobileID;strTasten_Name;strTastenfunktion;strDruckrichtung;dblX_Wert;dblY_Wert;dblZ_Wert;dbldX_Wert;dbldY_Wert;dbldZ_Wert;intTastendruck;intDauer;intAnzahl;strBewegungstyp");
for(int i = 0; i < count; i++)
{
buffer[i] = (Keyid+";"+MobileID+";"+"TS_Left_Bottom"+";"+";"+"mitte"+";"+ x[i]+";"+y[i] +";"+z+";"+0+";"+0+";"+0+";"+12000+";"+100+";"+1+";"+"XY-Z");
file.WriteLine(buffer[i]);
}
}
}
Hesham Hassanein12y ago
I think i know why, but don't know how to display it...

I want to display in the x column the whole xlist and in the ycolumn the whole ylist

so can i say

string[] buffer = new string[sizeof (x)];
but then

buffer[b - 1] = (Keyid + ";" + MobileID + ";" + "TS_Left_Bottom" + ";" + ";" + "mitte" + ";" + x + ";" + y + ";" + z + ";" + 0 + ";" + 0 + ";" + 0 + ";" + 12000 + ";" + 100 + ";" + 1 + ";" + "XY-Z");

I mean after displaying the headers in the first line of the csv the next line should be like the first one except the x and the y list should be displayed so that its going to be big csv file. you know what i mean?
Hesham Hassanein12y ago
using (System.IO.StreamWriter file = new System.IO.StreamWriter(ProgramPfad))
                {
                    file.WriteLine("intMobileID;strTasten_Name;strTastenfunktion;strDruckrichtung;dblX_Wert;dblY_Wert;dblZ_Wert;dbldX_Wert;dbldY_Wert;dbldZ_Wert;intTastendruck;intDauer;intAnzahl;strBewegungstyp");
                    string[] buffer = new string[1];
                    foreach (string strg in buffer)
                    {

                        file.WriteLine(strg);

                    }


                    buffer[b - 1] = (Keyid + ";" + MobileID + ";" + "TS_Left_Bottom" + ";" + ";" + "mitte" + ";" + x[0] + ";" + y[0] + ";" + z + ";" + 0 + ";" + 0 + ";" + 0 + ";" + 12000 + ";" + 100 + ";" + 1 + ";" + "XY-Z");

                    buffer[b] = (Keyid + ";" + MobileID + ";" + "TS_Left_Bottom" + ";" + ";" + "mitte" + ";" + x[1] + ";" + y[1] + ";" + z + ";" + 0 + ";" + 0 + ";" + 0 + ";" + 12000 + ";" + 100 + ";" + 1 + ";" + "XY-Z");

                }
            }
               reader.Close();
Hesham Hassanein12y ago
I am only getting this in the csv file

intMobileID;strTasten_Name;strTastenfunktion;strDruckrichtung;dblX_Wert;dblY_Wert;dblZ_Wert;dbldX_Wert;dbldY_Wert;dbldZ_Wert;intTastendruck;intDauer;intAnzahl;strBewegungstyp

I want the second row to have the x and y values
Vulpes12y ago
If you want to get the 'x' value from the other method, then you'll need to change it so that it returns a value:

static List RightBottom(int MobileID)
{
StreamReader reader = File.OpenText(@"C:\Robotron\Execution\TS_Right_Bottom.csv");
string line4;
List xList = new List();
List yList = new List();
List zList = new List();

while ((line4 = reader.ReadLine()) != null)
{
string[] fields = line4.Split(';');
if (fields.Length != 15) continue;
if (fields[1] == "intMobileID") continue;
int id = Convert.ToInt32(fields[1]);
if (id == MobileID)
{
xList.Add(fields[5]);
yList.Add(fields[6]);
zList.Add(fields[7]);

}
}

reader.Close();

if (xList.Count() > 0)
{
Console.WriteLine("The Corresponding Coordinates are: ");

for (int i = 0; i < xList.Count; i++)
{

Console.WriteLine(" {0} : {1} : {2}", xList[i], yList[i], zList[i]);

}
}
else
Console.WriteLine("There is no corresponding Information");
Console.ReadKey(); // might want to get rid of this
return xList;
}

The LeftBottom method will then need changing as follows:

static void LeftBottom(int MobileID)
{
string ProgramPfad = (@"C:\Robotron\Execution\"+MobileID+".csv");
int b = 2;
string linee;
List x = RightBottom(MobileId);
List y = new List();

int z = 25;
StreamReader reader = File.OpenText(@"C:\Robotron\Execution\TS_Right_Bottom.csv");
//StreamReader rdr = File.OpenText(@"C:\Robotron\Execution\TS_Left_Top.csv"); // no longer needed
while ((linee = reader.ReadLine()) != null)
{
string[] fields = linee.Split('\t');
if (fields.Length != 15) continue;
int Keyid = Convert.ToInt32(fields[0]);
int id = Convert.ToInt32(fields[1]);
if (id == MobileID)
{
//x.Add(fields[5]); // no longer needed
y.Add(fields[6]);
break;
}

reader.Close();

using (System.IO.StreamWriter file = new System.IO.StreamWriter(ProgramPfad))
{
file.WriteLine("intMobileID;strTasten_Name;strTastenfunktion;strDruckrichtung;dblX_Wert;dblY_Wert;dblZ_Wert;dbldX_Wert;dbldY_Wert;dbldZ_Wert;intTastendruck;intDauer;intAnzahl;strBewegungstyp");
string[] buffer = new string[1];
buffer[b - 2] = (Keyid+";"+MobileID+";"+"TS_Left_Bottom"+";"+";"+"mitte"+";"+ x[0]+";"+y[0] +";"+z+";"+0+";"+0+";"+0+";"+12000+";"+100+";"+1+";"+"XY-Z");
}
}
}
Hesham Hassanein12y ago
for example can i assign this value x[i] a string x and use it when writing the csv file and the same for y in the other file
Hesham Hassanein12y ago
well, there is no guarantee... but i already have two methods that are reading the two csv files

like this.. the other one is the same but with another file name and directory..

so how can i use the x from this method and the y from the other file to print it in the method of writing the csv

static void RightBottom(int MobileID)
        {
            StreamReader reader = File.OpenText(@"C:\Robotron\Execution\TS_Right_Bottom.csv");
            string line4;
            List xList = new List();
            List yList = new List();
            List zList = new List();

            while ((line4 = reader.ReadLine()) != null)
            {
                string[] fields = line4.Split(';');
                if (fields.Length != 15) continue;
                if (fields[1] == "intMobileID") continue;
                int id = Convert.ToInt32(fields[1]);
                if (id == MobileID)
                {
                    xList.Add(fields[5]);
                    yList.Add(fields[6]);
                    zList.Add(fields[7]);

                }
            }

            reader.Close();

            if (xList.Count() > 0)
            {
                Console.WriteLine("The Corresponding Coordinates are: ");

                for (int i = 0; i < xList.Count; i++)
                {


                    Console.WriteLine(" {0} : {1} : {2}", xList[i], yList[i], zList[i]);

                }
            }
            else
                Console.WriteLine("There is no corresponding Information");
            Console.ReadKey();
        }
Wim Sturkenboom12y ago
In your example, you're reading x and y from the same file. Now you want the y to come from another file.

Is there is a guarantee that line1 in file1 refers to the same mobile number as line 1 in file2 and that both files have the same amount of lines, you can read file2 in parallel. Something like

StreamReader reader = File.OpenText(@"C:\Robotron\Execution\TS_Right_Bottom.csv");
StreamReader rdr = File.OpenText(@"C:\Robotron\Execution\TS_Left_Top.csv");
while ((linee = reader.ReadLine()) != null)
{
string linefromfiletwo = rdr.ReadLine();
string fieldsfromfiletwo[] = linefromfiletwo.Split("\t");

string[] fields = linee.Split('\t');
if (fields.Length != 15) continue;
int Keyid = Convert.ToInt32(fields[0]);
int id = Convert.ToInt32(fields[1]);
if (id == MobileID)
{
x.Add(fields[5]);
//y.Add(fields[6]);
y.Add(fieldsfromfiletwo[6]);
break;
}
...
...

If there is no guarantee, you're better off reading both files separately and store the data in memory (e.g. in two datatables) and next process those tables.

Note that your approach to reading and writing csv files will cause problems if any of the fields in a record contains a '\t' (for the reading; you might have implemented the length check for that purpose, I'm not sure) or a semicolon (for the writing). There is a multitude of source code for csv readers and csv writers available on the web.

I have used the below (the first one is the writer):
http://knab.ws/blog/index.php?/archives/3-CSV-file-parser-and-writer-in-C-Part-1.html
http://knab.ws/blog/index.php?/archives/10-CSV-file-parser-and-writer-in-C-Part-2.html

Alternatively, you can use the (standard) TextFieldParser class for the reading.
Hesham Hassanein12y ago
well, yes this makes the csv file generated but what i want is to write the x value from the first csv file and the y value from the second csv file. so instead of this y.Add(fields[6]); y should be read from the second csv file. when i ran the code this is what was generated in one row. Thanks for your reply i really appreciate ur help intMobileID;strTasten_Name;strTastenfunktion;strDruckrichtung;dblX_Wert;dblY_Wert;dblZ_Wert;dbldX_Wert;dbldY_Wert;dbldZ_Wert;intTastendruck;intDauer;intAnzahl;strBewegungstyp
Vulpes12y ago
Well, x and y are lists of strings.

If they only have a single element (or you're only interested in the first element), then just replace 'x' and 'y' in the buffer expression with x[0] and y[0] respectively.

A couple of other points I've noticed:

1. I'd close 'reader' after you've finished with it.

2. You've set 'b' to 2 but the buffer array has only one element. Instead of buffer[b - 1] it should therefore be buffer[b - 2].