Trying to replace a substring of a string with another substring

Question

I'm trying to take this string

where lowercase(pdd.last_name) like 'albert%'

and replace "pdd" with "p" using this function

sb.replace(queryAdd.indexOf("pdd"), (queryAdd.indexOf("pdd") + 3), "p");

where sb is a StringBuffer, but it doesn't work and here's what it actually returns

where lowercase(pdpast_name) like 'albert%'

Why does this not replace "pdd" with "p"?

Yes i have. re-read the question please.

Catfish
– Catfish

2012-03-22 14:36:23 +00:00
Commented Mar 22, 2012 at 14:36 — Catfish
– Catfish, Commented Mar 22, 2012 at 14:36

TacticalCoder · Accepted Answer · 2012-03-22 14:40:48Z

2

StringBuffer s = new StringBuffer("where lowercase(pdd.last_name) like 'albert%'");
    s.replace(s.indexOf("pdd"),(s.indexOf("pdd")+3), "p");
    System.out.println(s);

I think your sb and queryAdd have different data.

edited Mar 22, 2012 at 14:40

TacticalCoder

6,3353 gold badges34 silver badges39 bronze badges

answered Mar 22, 2012 at 14:35

Chandra Sekhar

19.5k18 gold badges88 silver badges133 bronze badges

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

1 Comment

Catfish Over a year ago

Oh god i think you're right. I shouldn't have been using my queryAdd var for the index, but my string buffer as you've suggested. I've been trying to get this to work for wayyy too long. Thanks.

juergen d · Accepted Answer · 2012-03-22 14:32:55Z

1

Try this

String str = "where lowercase(pdd.last_name) like 'albert%'";
str = str.replaceFirst("pdd", "p");

answered Mar 22, 2012 at 14:32

juergen d

205k40 gold badges303 silver badges377 bronze badges

Comments

TacticalCoder · Accepted Answer · 2012-03-22 14:40:25Z

1

It worked in my case. Have a look at my code (I am assuming this is what you are trying to do)....

StringBuffer sb = new StringBuffer("where lowercase(pdd.last_name) like 'albert%'");
        String queryAdd="where lowercase(pdd.last_name) like 'albert%'";
        sb.replace(queryAdd.indexOf("pdd"), (queryAdd.indexOf("pdd") + 3), "p");
        System.out.println(sb);

Output: where lowercase(p.last_name) like 'albert%'

edited Mar 22, 2012 at 14:40

TacticalCoder

6,3353 gold badges34 silver badges39 bronze badges

answered Mar 22, 2012 at 14:34

Shashank Kadne

8,1017 gold badges43 silver badges54 bronze badges

Collectives™ on Stack Overflow

Trying to replace a substring of a string with another substring

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related