Replace substring from a string

Question

I have this string

String str=lookup('PRODUCT','LKP1','LKP_TAB1.ID')||('A'='B')-lookup('PRODUCT','LKP2','LKP_TAB1.ID')||'CON.ID'

This is just one example, in practical situation the lookup expression may exist any where and any number of times in the string. Also the string may have several other '(' and ')'. I need to convert the string to

=lookup('PRODUCT','LKP1','LKP_TAB1.ID',123)||('A'='B')-lookup('PRODUCT','LKP2','LKP_TAB1.ID',123)||'CON.ID'

It means I need to replace the ')' with ',123)' when it comes with lookup. But if it is not adjuscent with lookup then I dont wanna replace it.

Can this thing be done in java??

codaddict · Accepted Answer · 2012-02-10 10:47:46Z

1

Try:

str = str.replaceAll("(lookup\\([^)]*)\\)","$1,123)");

See it @ work

answered Feb 10, 2012 at 10:47

codaddict

457k83 gold badges501 silver badges537 bronze badges

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

Comments

duffymo · Accepted Answer · 2012-02-10 10:45:13Z

0

I think this is too much work and cleverness to be worth it.

I'd be lazy and have to final static instances, one String per case. Then I'd write an if test to decide which one to use.

Why do all that work every time? How many times will this operation be performed? If there are only two answers, spell them out. I think it'll be more readable and less load on the CPU.

answered Feb 10, 2012 at 10:45

duffymo

310k46 gold badges376 silver badges570 bronze badges

Comments

Ewald · Accepted Answer · 2012-02-10 10:47:11Z

0

Sure,

this can be done in any language, Java as well.

How about this :

Tokenize the string on ')'.

Then, if the token contains the word 'lookup', replace the last instance of ')' with '123)'.

I think that might work, it's ugly, but seems fine.

answered Feb 10, 2012 at 10:47

Ewald

5,7712 gold badges30 silver badges31 bronze badges

Collectives™ on Stack Overflow

Replace substring from a string

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related