Get string using RegEx in Java

Question

No matter how much I try to learn RegEx and implement them, I fail.

Below : The first value is the input string, values after colon are the terms I require from the string. The term will always be -> either Input! (A-Z) (number) or Calc! (A-Z) (number)

e.g.Input!A34 or Calc!D93.

Input : Need to replace with some constant/val

ADD(Input!A34 + Calc!D93) : Input!A34, Calc!D93

Input!D343 = 1000 : Input!D343

Calc!D71=IF(HasValue(Input!D4), "FormIs(PartofReturn)", IFERROR(1/0)): Calc!D71,Input!D4

What pattern should I use for this ?

My try :

Pattern findMyPattern = Pattern.compile("(?:Input|" + "Calc!"
                + ")![a-zA-Z]\\d+");
        Matcher foundAMatch = findMyPattern.matcher(input);
        HashSet hashSet = new HashSet();
        while (foundAMatch.find()) {
            String s = foundAMatch.group(0);
            hashSet.add(s);
        }

I dont understand your question. However "Input![A-Za-z]+\\d+|Calc![A-Za-z]+\\d+" Will this solve your problem? — Smit
– Smit, Commented Mar 20, 2013 at 23:42
I'm not understanding this either. Can you take another pass at it? I think there's an easy question in here, but your phrasing is convoluted. — Grant Birchmeier
– Grant Birchmeier, Commented Mar 20, 2013 at 23:45
Yes Maybe. But this problem is solved. Sorry for posting here guys. — Anuj Kulkarni
– Anuj Kulkarni, Commented Mar 20, 2013 at 23:49
(?:Input|Calc)![A-Z][1-9][0-9]* - either Input or Calc followed by ! and capital letter and, finally, the number — Dmitrii Bychenko
– Dmitrii Bychenko, Commented Sep 9 at 8:17

MikeM · Accepted Answer · 2013-03-20 23:44:49Z

1

Pattern findMyPattern = Pattern.compile("(?:Input|Calc)![A-Z]\\d+");

answered Mar 20, 2013 at 23:44

MikeM

13.8k3 gold badges38 silver badges49 bronze badges

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

Comments

President James K. Polk · Accepted Answer · 2025-09-09 15:36:09Z

0

Regex

Pattern p = Pattern.compile("\\b(?:Input|Calc)![A-Z]\\d+\\b");

Breakdown

(?:Input|Calc) — either keyword
! — the literal exclamation that both forms share
[A-Z] — exactly one uppercase column letter
\\d+ — one or more digits
\\b — word boundaries so you don’t bleed into adjacent text

Quick test with your samples

Matches found:

ADD(Input!A34 + Calc!D93) → Input!A34, Calc!D93
Input!D343 = 1000 → Input!D343
Calc!D71=IF(HasValue(Input!D4), "…") → Calc!D71, Input!D4

edited Sep 9 at 15:36

President James K. Polk

42.2k34 gold badges113 silver badges149 bronze badges

answered Sep 9 at 5:28

Xsu

404 bronze badges

Collectives™ on Stack Overflow

Get string using RegEx in Java

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