Is there any way to find data between two dates which are presend in same string and store it to json object

Question

I want to get String data after date in an object

Sample Input:
2019-06-06 13:01:53.263Z|abc|alfkdjas|alfjdlaksd|alkjdfs
2019-06-06 13:01:53.264Z|lkjsfadfi|sadofuoif
2019-04-01 16:47:25.327Z|ERROR 7816

Output: [{"date":"2019-06-06 13:01:53.263Z","data":"|abc| ldskjf "},{"date":"2019-06-06 13:01:53.264Z","data":"|lkjsfadfi"}]

Means i want the data after the first date until second date has come..

I tried to seperate data between two dates..

public static String ReadData() {

         BufferedReader reader;
           try {

               reader = new BufferedReader(new FileReader(logfilename));
               String line = reader.readLine();
               JSONArray jason=new JSONArray();
               JSONObject jo=new JSONObject();
               int count=0;
               while (true) {

                   if(line != null) {
                       if(count>0) {

                       }
                       if(isValidDate(line.split("\\|")[0])) {
                           count++;
                           jo.put("date", line.split("\\|")[0]);
jo.put("data",line);
                       }

                       line = reader.readLine();
                   }else {
                       break;
                   }


               }
               reader.close();
           } catch (IOException e) {
               e.printStackTrace();
           }
           return ""; 
     }

This function seperate my dates from the string...

public static boolean isValidDate(String inDate) {

 SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-DD HH:mm:ss.ms");           
     try {
            dateFormat.parse(inDate);

            } catch (ParseException pe) {
                return false;
            }
            return true;
       }

Input:
2019-06-06 13:01:53.263Z|abc| ldskjf
2019-06-06 13:01:53.264Z|lkjsfadfi

Output:

[{"date":"2019-06-06 13:01:53.263Z","data":"|abc| ldskjf "},{"date":"2019-06-06 13:01:53.264Z","data":"|lkjsfadfi"}]

I have a big size of log file here, and from that log file I want to convert that log file to a JSON array.

Answer 1

use substring instead

String res = "2019-06-06 13:01:53.263Z|abc|alfkdjas|alfjdlaksd|alkjdfs "
res0.substring(res0.indexOf('|'))  // 2019-06-06 13:01:53.263Z
res0.substring(0,res0.indexOf('|'))// |abc|alfkdjas|alfjdlaksd|alkjdfs 

Answer 2

It seems that you are looking for something like the following.

First, you need a method to read each line from a file. (If it is not line by line, please let me know. This is what I understand from your question).

This method will return an ArrayList containing each line of the input file.

public ArrayList<String> readAllLines(String filename){
    //ArrayList to hold all the lines
    ArrayList<String> lines = null;

    //Get lines of text (Strings) as a stream
    try (Stream<String> stream = Files.lines(Paths.get(filename))){
        // convert stream to a List-type object
        lines = (ArrayList<String>)stream.collect(Collectors.toList());
    }
    catch (IOException ioe){
        System.out.println("\nCould not read lines of text from the file.\n" +
                "Reason: parameter \"" + ioe.getMessage() + "\"");
    }
    catch (SecurityException se){
        System.out.println("Could not read the file provided." +
                "Please check if you have permission to access it.");
    }
    return lines;
}

Next, we need a method to determine if a String is a date, where we will use the method you posted in your own question.

public boolean isValidDate(String inDate) {
    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.ms");
    try {
        dateFormat.parse(inDate);
    }
    catch (ParseException pe) {
        return false;
    }
    return true;
}

Then, we will use a method to convert each String that we parse, into a JSONObject.

public JSONObject convertToJsonObject(String line){
    //Convert String into an ArrayList, split by "|" delimiter
    ArrayList<String> dataParts = new ArrayList<>(Arrays.asList(line.split("\\|")));
    String date=null;
    JSONObject jsonObj = new JSONObject();

    //Get the date, wherever it might be in the String and remove it from the List
    for(int i=0; i<dataParts.size(); i++){
        if (isValidDate(dataParts.get(i))){
            date = dataParts.get(i);
            dataParts.remove(i);
            break;
        }
    }
    //Add the date with key "date"
    jsonObj.put("date", date);
    //Add the rest of the data, with key "data" (while preserving the order)
    jsonObj.put("data", String.join("|", dataParts));

    return jsonObj;
}

Finally, we need the method that will tie all of the above together and produce the desirable result.

public JSONArray extractData(String filename){
    JSONArray jsonArray = new JSONArray();
    ArrayList<String> lines = readAllLines(filename);

    //For each line of the original text file, add the JSONObject to the JSONArray
    for (String line : lines)
        jsonArray.add(convertToJson(line));

    return jsonArray;
}

The usage in the main method would be:

public static void main(String[] a){
    MyClass myClass = new MyClass();
    JSONArray myArray = myClass.extractData("myTextFile.txt");
    System.out.println(myArray.toJSONString());
}

Output:

[{"date":"2019-06-06 13:01:53.263Z","data":"abc|alfkdjas|alfjdlaksd|alkjdfs"},{"date":"2019-06-06 13:01:53.263Z","data":"abc|al"}]

If the date is always the first occurrence in each line, then it would be better to use the String.substring() method to extract the date, just like @Luis Ramirez-Monterosa demonstrates in his answer.

My working, assumes that the date could be in the middle of the input String.

Answer 3

Extracting a date with the method you created isValid(), does not make any sense. That method will return a boolean type object (true or false).

By slightly modifying your method, you can create the following which extracts the date from the String examples you provided and finally returns a Date-type object:

public static Date extractDate(String inDate) {
    Date dt = null;
    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.ms");
    try {
        dt = dateFormat.parse(inDate);
    } 
    catch (ParseException pe) {
        pe.printStackTrace();
    }
    return dt;
}

Usage:

Date myDate = extractDate("2019-06-0613:01:53.263Z|abc|alfkdjas|alfjdlaksd|alkjdfs");

Output:

Thu Jun 06 13:03:03 BST 2019