/Java/Java comparing-two-csv-files-in-java

Java comparing-two-csv-files-in-java

import java.io.*;
import java.util.ArrayList;

/* file1 - file2 = file3*/
public class CompareCSV {
public static void main(String args[]) throws FileNotFoundException, IOException
{
    String path="D:\\csv\\";
    String file1="file1.csv";
    String file2="file2.csv";
    String file3="p3lang.csv";
    ArrayList al1=new ArrayList();
    ArrayList al2=new ArrayList();
    //ArrayList al3=new ArrayList();

    BufferedReader CSVFile1 = new BufferedReader(new FileReader(path+file1));
    String dataRow1 = CSVFile1.readLine();
    while (dataRow1 != null)
    {
        String[] dataArray1 = dataRow1.split(",");
        for (String item1:dataArray1)
        { 
           al1.add(item1);
        }

        dataRow1 = CSVFile1.readLine(); // Read next line of data.
    }

     CSVFile1.close();

    BufferedReader CSVFile2 = new BufferedReader(new FileReader(path+file2));
    String dataRow2 = CSVFile2.readLine();
    while (dataRow2 != null)
    {
        String[] dataArray2 = dataRow2.split(",");
        for (String item2:dataArray2)
        { 
           al2.add(item2);

        }
        dataRow2 = CSVFile2.readLine(); // Read next line of data.
    }
     CSVFile2.close();

     for(String bs:al2)
     {
         al1.remove(bs);
     }

     int size=al1.size();
     System.out.println(size);

     try
        {
            FileWriter writer=new FileWriter(path+file3);
            while(size!=0)
            {
                size--;
                writer.append(""+al1.get(size));
                writer.append('\n');
            }
            writer.flush();
            writer.close();
        }
        catch(IOException e)
        {
            e.printStackTrace();
        }
}}

Source: stackoverflow.com

Similar codes

0 vote156 views1 answer
Arrotondare un numero a 2 cifre dopo la virgola java
Java
0 vote154 views2 answers
Write a code to print second last word of input string
Java
0 vote161 views1 answer
What does this means error: cannot find symbol StorageRef.child(mUser()).putFile(imageUri).addOnCompleteListener(new OnCompleteListener<UploadTask.TaskSnapshot>()
Java
1 vote162 views2 answers
Scanner.hasnext()
Java
3 votes150 views1 answer
Java check if directory exists
Java
2 votes156 views1 answer
Spring boot resource optional request param
Java
1 vote182 views1 answer
String by byte array in java
Java
0 vote155 views1 answer
Get string match percentage java
Java
0 vote151 views1 answer
How to call values from methods in flutter
Java
0 vote155 views1 answer
* What went wrong: Value 'C:\Program Files\Java\jdk1.8.0_111' given for org.gradle.java.home Gradle property is invalid (Java home supplied is invalid)
Java