Answers
Please find the below implemented public static void q3() method. Also find the ProcessCSVFile class with q3 and main method to test the functionality of the q3 method.
Please find the below input dummy properties.csv and generated output.csv file by q3 method.
Please revert back in case anything else needs to do.
****** q3 method ******
public static void q3() {
Scanner sacnnerReader = null;
BufferedWriter bufferedWriter = null;
FileWriter fileWriter = null;
try {
File file = new File("properties.csv");
if (file.exists()) {
// creating File Writer to write CSV file
fileWriter = new FileWriter("output.csv");
// creating Buffered Writer to write CSV file
bufferedWriter = new BufferedWriter(fileWriter);
// creating sacnner Reader to read CSV file
sacnnerReader = new Scanner(file);
while (sacnnerReader.hasNextLine()) {
String line = sacnnerReader.nextLine();
String lineArray[] = line.split(",");
String name = lineArray[0];
int pure = Integer.parseInt(lineArray[2]);
if (name != null && (name.equals("refuse") || name.equals("being") ||
name.equals("poll") || name.equals("essential"))) {
bufferedWriter.write(name+","+pure);
bufferedWriter.newLine();
}
}
bufferedWriter.flush();
} else {
System.out.println("Input File not found");
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (sacnnerReader != null) {
sacnnerReader.close();
}
if (bufferedWriter != null) {
bufferedWriter.close();
}
if (fileWriter != null) {
fileWriter.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
****** ProcessCSVFile Class ********
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileWriter;
import java.io.IOException;
import java.util.Scanner;
public class ProcessCSVFile {
public static void main(String[] args) {
q3();
}
public static void q3() {
Scanner sacnnerReader = null;
BufferedWriter bufferedWriter = null;
FileWriter fileWriter = null;
try {
File file = new File("properties.csv");
if (file.exists()) {
// creating File Writer to write CSV file
fileWriter = new FileWriter("output.csv");
// creating Buffered Writer to write CSV file
bufferedWriter = new BufferedWriter(fileWriter);
// creating sacnner Reader to read CSV file
sacnnerReader = new Scanner(file);
while (sacnnerReader.hasNextLine()) {
String line = sacnnerReader.nextLine();
String lineArray[] = line.split(",");
String name = lineArray[0];
int pure = Integer.parseInt(lineArray[2]);
if (name != null && (name.equals("refuse") || name.equals("being") ||
name.equals("poll") || name.equals("essential"))) {
bufferedWriter.write(name+","+pure);
bufferedWriter.newLine();
}
}
bufferedWriter.flush();
} else {
System.out.println("Input File not found");
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (sacnnerReader != null) {
sacnnerReader.close();
}
if (bufferedWriter != null) {
bufferedWriter.close();
}
if (fileWriter != null) {
fileWriter.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
****** properties.csv ******
***** output.csv *******