Regular expression to fetch age value after [agebands_1]

[Aleem_Khan (crazy bot)]

Hi Guys
Hope you all doing good, Can you please help me to get age value from ms word document. I have below screen shot data in ms word file and I need to fetch value after
“[agebands_1]” and before “-” like 18. How can I get it by using regex.

[Gokul001 (Gokul Balaji)]

Hi @Aleem_Khan

You can install Uipath.word.Activities Package. you can use word application scope and read text activity to read the file and get the output as string.

Regards
Gokul

[Aleem_Khan (crazy bot)]

I need Regex because I am using get text activity and store data in string.

[Gokul001 (Gokul Balaji)]

Can you share the Expected output @Aleem_Khan

[Gokul001 (Gokul Balaji)]

Hi @Aleem_Khan

Try this below expression

User assign activity
LHS - Create an variable
RHS - System.Text.RegularExpressions.Regex.Match(“Input String”.Trim,“(?<=\d])\s+\d+(?=\s-)”).ToString

regex101: build, test, and debug regex

Hope it works

Regards
Gokul

[Aleem_Khan (crazy bot)]

@Gokul001

(?<=\d])\s+\d+(?=\s-)

I need value after [agebands_1]” and before “-” like 18

[Gokul001 (Gokul Balaji)]

Only you need the value [agebands_1] @Aleem_Khan

[Aleem_Khan (crazy bot)]

yes I need value [agebands_1]” and before “-” like 18
“[agebands_1]” keyword is unique in my string so I need value after this and before -

[Gokul001 (Gokul Balaji)]

Try this pattern @Aleem_Khan

(?<=agebands_1])\s+\d+(?=\s-)

Regards
Gokul

[Aleem_Khan (crazy bot)]

I have written in text file its come like below format

[Gokul001 (Gokul Balaji)]

Can you share it in the Text file with preservative format @Aleem_Khan

[Gokul001 (Gokul Balaji)]

Hi @Aleem_Khan

Try this expression

Use assign activity
LHS - Create an variable (TestData)
RHS - System.Text.RegularExpressions.Regex.Match(“Input String”.Trim,“(?<=agebands_1])\s+a\d+(?=\s-)”).ToString

Use assign activity
LHS - Create an variable
RHS - System.Text.RegularExpressions.Regex.Match(TestData.Trim,“\d+”).ToString

regex101: build, test, and debug regex

Hope it will resolve your query

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Kindly mark the appropriate post as solved, If you query is resolved @Aleem_Khan

So, that it will help others to

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

Regards
Gokul

[Aleem_Khan (crazy bot)]

Hi resolve this problem by using split method