Extract text from string inbetween ( ) (Multiple substracts)

[JDK (Josef R.)]

Hi there,

I am trying to extract specific text inbetween ( ) from a string with text.

Example of text:
Tab Page

The SA (551503809755) cannot be stopped on 2019‑07‑23, which is before its start date (2019‑07‑24)

So far I have done this with multiple assigns and substring with specific numbers for substract. But I would like it to be as dynamic as possible, and substracting all text/numbers between ( )

Any tips ideas?

[AshwinS2 (Ashwin S)]

@JDK

SA (551503809755)

Hi @JDK

Use matches activities

and give the regularexpression as (\d+)

Thanks
Ashwin S

[JDK (Josef R.)]

Thanks for the fast reply, @AshwinS2
I have never tried Matches before. Could you show me how to setup from picture?

[JDK (Josef R.)]

Error code: System.Linq.Enumerable+d__97`1[System.Text.RegularExpressions.Match]

[srdjan.suc]

In Matches activity you have Input property, this is where you put your whole string, then Pattern property, this is where you put your Pattern (in double quotes) and you can use CTRL+K to create RegexResult in Result property.

After that you can use RegexResult(0).Value (where 0 is first match, 1 is second match etc…) to get the desired result

[Vashisht (Vashisht Devasani)]

Hi @JDK,
Use like this, its working…

And check this the pattern condition is wrong…before…

Cheers…
Vashisht.

[JDK (Josef R.)]

Thank you so much for the explanation - its working for me aswell now

[Vashisht (Vashisht Devasani)]

If you find it useful mark it as solution and close the thread bro…
If any issues ping me…
Cheers…
Vashisht.

[JDK (Josef R.)]

Thank you very much