CSV converter Learn programming Java

Lesson:

File Management


Exercise:

CSV converter 56


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


Code:

package ReaderCSV;
import java.util.*;

public class Main
{
	public static void main(String[] args)
	{
		System.out.println("CSV READER");
		System.out.println("--------------------------------------");
		System.out.print("Enter name of file .csv: ");

		String nameFile = new Scanner(System.in).nextLine();
		java.io.InputStreamReader myfile;
		String cadena;
		int position;

		try
		{
			myfile = new java.io.InputStreamReader(nameFile, System.Text.Encoding.Default);
			String line;
			do
			{
				line = myfile.ReadLine();
				if ((line != null) && (!line.equals("")))
				{
					try
					{
						line = line.replace("\"", "");

						position = line.indexOf(';');
						cadena = line.substring(0, position);
						line = tangible.StringHelper.remove(line, 0, position + 1);
						System.out.println(cadena + "\n");

						position = line.indexOf(';');
						cadena = line.substring(0, position);
						line = tangible.StringHelper.remove(line, 0, position + 1);
						System.out.println(cadena + "\n");

						position = line.indexOf(';');
						cadena = line.substring(0, position);
						line = tangible.StringHelper.remove(line, 0, position + 1);
						System.out.println(cadena + "\n");

						cadena = line.substring(0);
						System.out.println(cadena + "\n");
					}
					catch (RuntimeException e)
					{
						System.out.println("Error !!! " + e.getMessage());
					}
				}
			} while (line != null);
		}
		catch (RuntimeException e)
		{
			System.out.println("Error !!!" + e.getMessage());
		}
	}
}