Converting Date into Day, Month, Year

[Eric Tan]

I have a text file that shows like this in every row

Testing,Fri 12/15/06,Fri 12/15/06,0 hrs


i will be using a delimiter to tokenized it by the symbol " , ". the problem now is the text files contain the day and date together as one attribute. how can i cut the day off and just read the date and split the dates into month/day/year? so that i can generate the gantt chart using this values?

can anyone help me on this? Thanks

[Ulf Dittmer]

The java.text.SimpleDateFormat class is helpful for this. Something like the following might do the trick (haven't tested this, so there might be problems, but you get the idea):

SimpleDateFormat sdf = new SimpleDateFormat("EEE MM/dd/yy");
Date dt = sdf.parse("Fri 12/15/06");

[pascal betz]

- or use another (or the same ?) Tokenizer to split the date string by '/'
- or use java.util.Regexp

pascal

[Eric Tan]

yea. i got what you meant. look through it already. thanks alot for the info. now i have small little problem. as everyone know that i am using Stringtokenizer to read the token to token. the problem i tried how to embed the SimpleDateFormat into StringTokenizer to read it into day, month, year but fail. can anyone guide me on this?


and another update is, the user that pass me the text file successfully grab it without have the day together the date
so the text file will be read in this way

Testing,12/15/06,12/15/06

so this will be the new type of data that i have to read. another issue is, can i use StringTokenizer to start reading only from the 2nd line because the 1st line is just the header of the file??

thanks alot guys. for your help. really appreciate it

[Ulf Dittmer]

I'm not sure what you mean by "embed the SimpleDateFormat into StringTokenizer". The tokenizer works in a loop (typically while { ... } ). In that loop you'd have the code I mentioned before. If you post that section of your code we could take a look at it.

StringTokenizer (or any other way to split up text) will not help with skipping the first line, because it only works on full lines of text. Skipping the first line must be accomplished by the code reading the file. Something like this will do the trick:

BufferedReader br = new BufferedReader(new FileReader(fileName));
String line;
boolean isFirstLine = true;
SimpleDateFormat sdf = new SimpleDateFormat("EEE MM/dd/yy");
 
while ((line = br.readLine()) != null) {
if (isFirstLine) {
isFirstLine = false;
continue;
}
StringTokenizer st = new StringTokenizer(line, ",");
while (st.hasMoreTokens()) {
Date dt = sdf.parse(st.nextToken());
...

[Eric Tan]

this is a workable sample i got the net. i want to ask some help on, how to retrieve just the day or the month from the startDate? for example, 2001-01-01... so if i want to display the day, it's going to print out "01". how can i do that? can anyone guide me one this? i tried on the codes that i just bold on. but still got error

package com;
 
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
 
public class MainClass {
 
  public static void main(String[] a) throws Exception{
 
    DateFormat df = new SimpleDateFormat ("yyyy-MM-dd");
 
    Date startDate = df.parse("2001-01-01");
 
    Date endDate = df.parse("2000-01-01");
 
    String relation = null;
    if (startDate.equals(endDate))
      relation = "the same date as";
    else if (startDate.before(endDate))
      relation = "before";
    else if (startDate.after(endDate))
      relation = "after";
    System.out.println(startDate + " is " + relation + ' ' + endDate);
[B] System.out.println(startDate.getDate());[/B]
       
  }
}
 

[Ulf Dittmer]

but still got error

What does this mean - are you getting an exception? If so, tells us which one it is, and in which line it occurs.

Note that the methods of the Date class will not return something like "01", because they only deal with integers, not strings. If you want all days to have two digits, you'll need to add a line of code that prepends the zero if the value is smaller than 10.
[ November 27, 2006: Message edited by: Ulf Dittmer ]