reading in a time that includes milliseconds

[ndedhia1]

I was reading in a log file like this that had no milliseconds:

QuoteBlockTiming exceeded 1 ms: 1 --- Thu Dec 10 02:01:40 CST 2009 170.137.15.155 Class key = 601650761 block size
QuoteBlockTiming exceeded 1 ms: 1 --- Thu Dec 10 02:01:40 CST 2009 170.137.15.155 Class key = 606887631 block size
QuoteBlockTiming exceeded 1 ms: 1 --- Thu Dec 10 02:01:40 CST 2009 170.137.15.155 Class key = 154517966 block size
QuoteBlockTiming exceeded 1 ms: 1 --- Thu Dec 10 02:01:40 CST 2009 170.137.15.155 Class key = 69220249 block size
QuoteBlockTiming exceeded 1 ms: 1 --- Thu Dec 10 02:01:40 CST 2009 170.137.15.155 Class key = 575941474 block size
 

and I was outputting it to an excel file like this:

Class Key    Date    Start Time    End Time    Length(ms)    Block Size    Class    BC (TS)    Product    Class Key    Class Type    Outlier Host    First Tick    Open. Rot.    Open. (ms)    Class Thread #
606887631    Thu Dec 10    02:01:40    02:01:40    1    1        Unidentified                perfgl15                20
533476053    Thu Dec 10    02:01:40    02:01:40    1    1        Unidentified                perfgl15                28
530369105    Thu Dec 10    02:01:40    02:01:40    1    1    ARB    BC20(1)    ARB    530369105    3    perfgl15                24
69208240    Thu Dec 10    02:01:40    02:01:40    1    1    BLSW    BC20(2)    BLSW    69208240    3    perfgl15                1
575941474    Thu Dec 10    02:01:40    02:01:40    1    1    CBOU    BC20(3)    CBOU    575941474    3    perfgl15.                24
601650761    Thu Dec 10    02:01:40    02:01:40    1    1    DNY    BC20(4)    DNY    601650761    3    perfgl15.            28
 

I was going thru the log file, using spaces as new fields and when i got to the time, i was reading in the time using the ':' as a deliminator and reading in the hrs, min and seconds as ints creating a Calendar variable after putting the individual fields into the GregorianCalendar constructor like this:

if (input.startsWith("QuoteBlockTiming")) {
            boolean sessionSet = false;
            StringTokenizer ST = new StringTokenizer(input, " \t");
            while (ST.hasMoreTokens()) {
                String thisToke = ST.nextToken();
                if (thisToke.equalsIgnoreCase("ms:")) {
                    returner.setM_duration(new Integer(ST.nextToken()).intValue());
                    ST.nextToken();
                    ST.nextToken();
                    String strMonth = ST.nextToken();
                    int intMonth = convertMonth(strMonth);
                    Integer intMonthDay = new Integer(ST.nextToken());
                    String strTime = ST.nextToken();
                    StringTokenizer ST2 = new StringTokenizer(strTime, ":");
                    Integer intHour = new Integer(ST2.nextToken());
                    Integer intMinute = new Integer(ST2.nextToken());
                    Integer intSecond = new Integer(ST2.nextToken());
                    ST.nextToken();
                    Integer intYear = new Integer(ST.nextToken());
 
                    Calendar cal = new GregorianCalendar(intYear.intValue(),intMonth,
                          intMonthDay.intValue(),intHour.intValue(),intMinute.intValue(),
                        intSecond.intValue());
 
                   returner.setM_date(cal.getTime());
 

NOW, with milliseconds in the log file that looks like this:

QuoteBlockTiming exceeded 1 ms: 1 --- Thu Dec 10 02:01:40.364 CST 2009 170.137.15.155 Class key = 601650761 block size
QuoteBlockTiming exceeded 1 ms: 1 --- Thu Dec 10 02:01:40.364 CST 2009 170.137.15.155 Class key = 606887631 block size
QuoteBlockTiming exceeded 1 ms: 1 --- Thu Dec 10 02:01:40.364 CST 2009 170.137.15.155 Class key = 154517966 block size
QuoteBlockTiming exceeded 1 ms: 1 --- Thu Dec 10 02:01:40.366 CST 2009 170.137.15.155 Class key = 69220249 block size
QuoteBlockTiming exceeded 1 ms: 1 --- Thu Dec 10 02:01:40.366 CST 2009 170.137.15.155 Class key = 575941474 block size
QuoteBlockTiming exceeded 1 ms: 1 --- Thu Dec 10 02:01:40.367 CST 2009 170.137.15.155 Class key = 154517966 block size
 

I need to put the milliseconds in the excel file also.

I was thinking about changing the line:
Integer intSecond = new Integer(ST2.nextToken()); INTO
Double intSecond = new Double(ST2.nextToken());

but the GregorianCalendar doesnt have a constructor that has a double argument that it accepts.

I was also thinking about using SimpleDateFormat but i was unsure of how to use that.

I really only need the hours:minutes:seconds.milliseconds in any kind of format

Please help.

Thanks

[chaarmann]

You are separating the time-string at ":", Before you had for example seconds="40". With the new data you have seconds="40.364".
So you cannot convert that to an integer anymore like before! Just separate this string at "." and assign the first part to seconds, the second part to milliseconds!

String strSeconds = ST2.nextToken();
StringTokenizer ST3 = new StringTokenizer(strSeconds , "."); 
Integer intSecond = new Integer(ST3.nextToken()); 
Integer intMilliseconds = new Integer(ST3.nextToken());
 

By the way, StringTokenizer is old stuff! Just use Regular Expressions!
With regular expressions, you could do all your splitting at once and less code.
Look here:

    import java.util.regex.*
 
    CharSequence inputStr = "QuoteBlockTiming exceeded 1 ms: 1 --- Thu Dec 10 02:01:40.364 CST 2009 170.137.15.155 Class key = 601650761 block ...";
    String patternStr = " --- (...) (...) (..) (..):(..):(..)\\.(...) CST (....) ";
 
    Matcher matcher = Pattern.compile(patternStr).matcher(inputStr);    
    if (matcher.find()) {
       String all =         matcher.group(0); // whole String " --- Thu Dec 10 02:01:40.364 CST 2009 "
       String dayInWeek =   matcher.group(1); // returns "Thu"
       String month =       matcher.group(2); // returns "Dec" 
       String dayInMonth =  matcher.group(3); // returns "10"
       String hour =        matcher.group(4); // returns "02"
       String minute =      matcher.group(5); // returns "01"
       String second =      matcher.group(6); // returns "40"
       String millisecond = matcher.group(7); // returns "364"
       String year=         matcher.group(8); // returns "2009"
    }