Regular Expression to find & replace specific substring

Question

I want regular expression to find & replace first and third rownum word in the below-given string with the word NONE.

String str = "select dummy,rownum,rowid as \"rownum\",rownum as order_number from dual";

I have tried below regular expression but it replacing the comma , before or after the word rownum

str = str.replaceAll("(?i)[^\"A-Z0-9]rownum[^$\"A-Z0-9]"," NONE ")

Actual Output : select dummy NONE rowid as "rownum" NONE as order_number from dual

Expected Output : select dummy,NONE, rowid as "rownum",NONE as order_number from dual

Pshemo · Accepted Answer · 2018-03-15 18:13:47Z

1

If you want to avoid replacing "rownum" because it is surrounded by " then you can use look-around mechanisms to forbid " before or after it like

String str = "select dummy,rownum,rowid as \"rownum\",rownum as order_number from dual";
str = str.replaceAll("(?i)(?!<\")\\brownum\\b(?!\")"," NONE ");
System.out.println(str);

Output: select dummy, NONE ,rowid as "rownum", NONE as order_number from dual

But that solution is valid only for this particular scenario. If you have other ones you should search for SQL parsers instead of RegEx.

answered Mar 15, 2018 at 18:13

Pshemo

125k26 gold badges194 silver badges280 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pshemo · Accepted Answer · 2018-03-15 18:08:38Z

0

You can try this, it's works

str = str.replace("rownum", "NONE");
str = str.replace("\"NONE\"", "\"rownum\"");

edited Mar 15, 2018 at 18:08

Pshemo

125k26 gold badges194 silver badges280 bronze badges

answered Mar 15, 2018 at 17:50

slnit

356 bronze badges

Collectives™ on Stack Overflow

Regular Expression to find & replace specific substring

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related