Removing string before open parenthesis using regular expression

Question

I have an expression Nvl(cost,Sum(cost1)) i need to remove string before paranthesis i.e NVl and Sum in this case

        String functions=externalFormat.replaceAll("\\([^\\(]*\\)", "");

Input Nvl(cost,Sum(Cost1) Output cost,cost1

Although not a neat way but you can use \w+\(|\) and replace with empty string. — Pushpesh Kumar Rajwanshi
– Pushpesh Kumar Rajwanshi, Commented May 16, 2019 at 11:55

Jamie D · Accepted Answer · 2019-05-16 12:07:32Z

1

If you can't use capture groups (ie, if you CAN use capture groups, (\w*?)\( will capture the text you need to replace in the first group)

You could use a positive look-ahead to only capture word characters (letter or number) that appear before an open bracket:

\w*(?=\()

You could even add optional white space characters in case of things like: Nvl1 (cost,Sum (cost1)) by including them before the look-ahead: -

\w*\s*(?=\()

Hope this helps solve your problem.

answered May 16, 2019 at 12:07

Jamie D

1,40710 silver badges20 bronze badges

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

Comments

IMParasharG · Accepted Answer · 2019-05-16 12:08:20Z

0

Check below code :

public static void main(String[] args) {
        String externalFormat="Nvl(cost,Sum(Cost1)";
        String functions=externalFormat.replaceAll("\\w+\\(|\\)", "");
        System.out.println(functions.toLowerCase());

    }

answered May 16, 2019 at 12:08

IMParasharG

1,9051 gold badge15 silver badges27 bronze badges

Collectives™ on Stack Overflow

Removing string before open parenthesis using regular expression

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