StringTokenizer ??

[Tom Caldwell]

I'm sure this is easy to do but I'm not getting it. ?
All I need to do is parse a string in the middle and take the 2nd half as in
select * from table where something = something
I need to get from "where" on, isn't StringTokenizer the way to do this ?
Thanks

[Sean MacLean]

Actually, I thought the same but it seems that a string tokenizer can't parse based on strings (only characters). You pass a string to the constructor but this is treated as a list of delimiters not as a single delimiter. So, short of using a regex package, you could use some of the String methods like so.

public class Test {
    public static String[] parseSQL( String sql, String delim ) {
        String[] results = new String[2];
        results[0] = sql.substring( 0, sql.toUpperCase().indexOf( delim.toUpperCase() ) ).trim();
        results[1] = sql.substring( sql.toUpperCase().indexOf( delim.toUpperCase() ) +
                                    delim.length(), sql.length() ).trim();
        return results;
    }
    public static void main( String[] args ) {
        String sqlString = "Select * from table Where something = something";
        String[] results = parseSQL( sqlString, "Where" );
        System.out.println( results[0] );
        System.out.println( results[1] );
    }
}

Sean
[This message has been edited by Sean MacLean (edited June 22, 2001).]

[Tom Caldwell]

Thanks Sean,
That works fine, I'll use it.
Still seems like a lot of work to do something so simple ?

[Sean MacLean]

Well, there's promise for the future. Java 1.4 (beta) includes a java regex api. This will really help with string manipulation.
Sean