CODEWITHSUNDEEP
javatext-filestext-extraction
John
John

Reputation: 35

Java Extracting values from text files

I have many text files (up to 20) and each file has it's contents like this 

21.0|11|1/1/1997
13.3|12|2/1/1997
14.6|9|3/1/1997

and every file has approximately more than 300 lines.

so the problem I'm facing is this, how can I extract all and only the first values of the file's content.

for example I want to extract the values (21.0,13.3,14.6.....etc) so I can decide the max number and minimum in all of the 20 files.

I have wrote this code from my understanding to experience it on of the files but it didn't work 

  String inputFileName = "Date.txt";
 File inputFile = new File(inputFileName);
 Scanner input = new Scanner(inputFile);
 int count = 0;
 while (input.hasNext()){
     double line = input.nextDouble(); //Error occurs "Exception in thread "main" java.util.InputMismatchException" 
     count++;
     double [] lineArray= new double [365];
     lineArray[count]= line;
     System.out.println(count);
      for (double s : lineArray){
       System.out.println(s);
          System.out.println(count);

and this one too

 String inputFileName = "Date.txt";
 File inputFile = new File(inputFileName);
 Scanner input = new Scanner(inputFile);

 while (input.hasNext()){
     String line = input.nextLine();
     String [] lineArray = line.split("//|");
      for (String s : lineArray){
       System.out.println(s+" ");
 }

I hope I was clear and thanks

Upvotes: 2

Views: 13448

Answers (3)

Łukasz
Łukasz

Reputation: 8663

Or you could try some streams, cool stuff

import java.io.IOException;
import java.nio.file.Files;
import java.nio.file.Path;
import java.nio.file.Paths;
import java.util.Arrays;
import java.util.List;
import java.util.stream.Collectors;
import java.util.stream.Stream;

public class MinMaxPrinter {

    public static void main(String[] args) {
        final List<String> files = Arrays.asList("file", "names", "that", "you", "need");

        new MinMaxPrinter().printMinMax(files);
    }

    public void printMinMax(List<String> fileNames) {
        List<Double> numbers = fileNames.stream()
                .map(Paths::get)
                .flatMap(this::toLines)
                .map(line -> line.split("\\|")[0])
                .map(Double::parseDouble)
                .collect(Collectors.toList());

        double max = numbers.stream().max(Double::compare).get();
        double min = numbers.stream().min(Double::compare).get();

        System.out.println("Min: " + min + " Max: " + max);
    }

    private Stream<String> toLines(Path path) {
        try {
            return Files.lines(path);
        } catch (IOException e) {
            return Stream.empty();
        }
    }
}

Upvotes: 1

user3437460
user3437460

Reputation: 17454

For each line of text, check whether it contains the pipe character. If it does, grab the first portion of the text and parse it to double.

double val = 0.0;
Scanner fScn = new Scanner(new File(“date.txt”));
while(fScn.hasNextLine()){   //Can also use a BufferedReader
    data = fScn.nextLine();
    if(data.contains("|"))    //Ensure line contains "|"
        val = Double.parseDouble(data.substring(0, data.indexOf("|")));  //grab value
}

Upvotes: 2

Srinivasu
Srinivasu

Reputation: 1235

try (BufferedReader br = new BufferedReader(new FileReader(file))) {
    String line;
    while ((line = br.readLine()) != null) {
      String res = s.split("\\|")[0];
    }
}

Upvotes: 0

Related Questions