How to parse String effectively based on a dilimiter

[DonCash]

Ah nice one Chris. Yeah that explains it well.

[Chris.Brown.SPE]

Take a look at this,

Code:

  public static void main(String[] args) {

    String statement = "update employee\nset wtKey = name||pno||id\nwhere id is not null";
    String concat = "";
    String[] temparray, temparray2, temparray3;
    temparray = statement.split("=.?");//splits off equals sign and space afterwards
    temparray2 = temparray[1].split("\\n");//splits off last line
    concat = temparray2[0];//grabs the concat part of it
    temparray3 = concat.split("\\|\\|");//splits up by ||
    concat = " CONCAT(" + temparray3[0] + "," + temparray3[1] + "," + temparray3[2] + ")";//puts concat together
    statement = temparray[0] + "=" + concat + "\n" + temparray2[1];//reassembles statement
    System.out.println(statement);//output statement

  }

Output:
update employee
set wtKey = CONCAT(name,pno,id)
where id is not null

[Eranga]

What this mean pal.

[DonCash]

Its the desired SQL query output he was looking for.... Good work Chris.

[Eranga]

Ah, I got it.

Users better to mentioned some tips if the thread goes for more than one page, isn't it Don.

[raghu408]

Chris that's so nice of you but my API here should be dynamic i.e not specific to one SQL like i mentioned above:update employee\nset wtKey = name||pno||id\nwhere id is not null

but if you send a valid query like:
SELECT region_name || ' ' || store_name FROM Geography
WHERE store_name = 'Boston';

Then it should return:

region_name || ' ' || store_name

basically it should return all that are connected with ||

[Chris.Brown.SPE]

Try this out.

Code:

  static String compute(String temp) {
    String concat;//holds final concat
    String[] temparray;//holds parts after split
    String first, second, third;//divides three parts into three strings
    temparray = temp.split("\\|\\|");// splits up by ||
    first = temparray[0].substring(temparray[0].lastIndexOf(' ', temparray[0].length() - 2) + 1);//takes off first part by removing everything past last space
    second = temparray[1];//second part goes into  string
    if (temparray[2].indexOf(' ', 1) < temparray[2].indexOf(10, 1) | temparray[2].indexOf(10, 1) == -1) {//takes last part by removing everything until first space or line feed
      third = temparray[2].substring(0, temparray[2].indexOf(' ', 1));//in case of space
    } else {
      third = temparray[2].substring(0, temparray[2].indexOf(10, 1));//in case of line feed
    }
    concat = first + "||" + second + "||" + third;//builds the concat info
    return concat;
  }