Replace String

[Edward Durai]

Consider i have string like

"select [columnName] from tablename"

I want to replace [columnName] to [UserName]

finally, i need "select [UserName] from tablename";

how?

[Freddy Wong]

Use regular expression. Take a look at Pattern and Matcher classes.

[Ulf Dittmer]

Something like the following may do the trick. You'll need to add a loop to deal with the case when findStr can occur more than once in targetStr. (The indices may be off, but you get the idea.)

String findStr = "columnName";
String replaceStr = "replStr";
String targetStr = "select [columnName] from tablename";
 
int idx = targetStr.indexOf("["+findStr+"]");
if (idx > -1) {
    resultStr = targetStr.substring(0, idx) + replaceStr + targetStr.substring(idx+findStr.length()+2);
}

[Rahim Vindhani]

isnt it as simple as

String targetStr = "select columnName from tablename";
targetStr= targetStr.replace("columnName", "username").replace("tablename", "users");

if its more than one time, You can use replaceAll (only JDK 1.4 and later I guess)