Use case for String split

Question

I want code snippet for splitting the below string:

Input : select * from table where a=? and b=? and c=?

Output: 
    Str1: select * from table where a=?
    Str2: and b=? 
    Str3: and c=?

I do not want to use indexof as of now, whether StringUtils or regex can help me here? I was looking for StringUtilus but I did not get anything in it. Your input is appreciated.

You should post what you have tried so far. – Jerry Sep 03 '13 at 07:40 — Jerry, Sep 03 '13 at 07:40

score 1 · Answer 1 · answered Sep 03 '13 at 07:41

1

This should suffice:

inputStr.split("(?=\band\b)")

answered Sep 03 '13 at 07:41

Amadan

191,408
23
240
301

score 1 · Answer 2 · answered Sep 03 '13 at 07:43

1

If you are trying it in php then try ,

$myvar = explode('and','select * from table where a=? and b=? and c=? ');
$str1 = $myvar[0];
$str2 = $myvar[1];
$str3 = $myvar[2];

answered Sep 03 '13 at 07:43

yantrakaar

374
3
15

score 1 · Answer 3 · answered Sep 03 '13 at 08:12

1

I got, we can use

    String str = "select * from table where a=? and b=? anc c=?";
    String[] tokens = str.split("\\?");

    for (String string : tokens) {
        System.out.print("tokens: "+string);
    }

answered Sep 03 '13 at 08:12

Rahul

41
2

Use case for String split

3 Answers3