Practice Exercises C# Sharp - Learn to program with performing exercises C# Sharp

Practice Exercises C# Sharp

Learn to program with performing exercises C# Sharp


CSV converter - Practice Exercises C# Sharp


Lesson 8:

File management


Exercise 8.30:

CSV converter


Objetive:

The CSV ("Comma Separated Values") is a exchange format used by many spreadsheets and management systems databases. It is a series of comma-separated values enclosed in quotation marks, although there are variants that do not use quotes, or using semicolon as separator. Often the figures not enclosed in quotes. An example file would be:

"John", "López Pérez," "Alicante", 25
"Antonio", "Pérez López", "Madrid", 27

It should create a program that reads a CSV file as above, with four data blocks (the first 3 are text and the last will be numeric), each of which is in a line, and generate a text file each entry contains a line like this:

John
Pérez López
Alicante
25
Anthony
Pérez López
Madrid
27


Source Code:


using System;
using System.IO;
namespace ReaderCSV
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("CSV READER");
            Console.WriteLine("--------------------------------------");
            Console.Write("Enter name of file .csv: ");

            string nameFile = Console.ReadLine();
            StreamReader myfile;
            string cadena;
            int position;

            try
            {
                myfile = new StreamReader(nameFile, System.Text.Encoding.Default);
                string line;
                do
                {
                    line = myfile.ReadLine();
                    if ((line != null) && (line != ""))
                    {
                        try
                        {
                            line = line.Replace("\"", "");

                            position = line.IndexOf(';');
                            cadena = line.Substring(0, position);
                            line = line.Remove(0, position + 1);
                            Console.WriteLine(cadena + "\n");

                            position = line.IndexOf(';');
                            cadena = line.Substring(0, position);
                            line = line.Remove(0, position + 1);
                            Console.WriteLine(cadena + "\n");

                            position = line.IndexOf(';');
                            cadena = line.Substring(0, position);
                            line = line.Remove(0, position + 1);
                            Console.WriteLine(cadena + "\n");

                            cadena = line.Substring(0);
                            Console.WriteLine(cadena + "\n");
                        }
                        catch (Exception e)
                        {
                            Console.WriteLine("Error !!! " + e.Message);
                        }
                    }
                }
                while (line != null);
            }
            catch (Exception e)
            {
                Console.WriteLine("Error !!!" + e.Message);
            }
        }
    }
}
Exercisey 8.30




Privacy Policy:



Google uses associated advertising companies to serve ads when it visits our website. These companies may use the information they obtain from your visits to this and other websites (not including your name, address, email address, or phone number) to provide you with announcements about products and services that interest you. If you would like to learn more about this practice and know your options to prevent these companies from using this information. Click in... Privacy and Terms of Google.

Cookies

This site uses Google cookies to provide its services, to personalize advertisements and to analyze traffic. Google receives information about your use of this website. More information in... Privacy and Terms of Google.