Can you help me to get Regular expression for below

Help Studio
, ,
1

Hi All,

I need to get the Regular Expressions to fetch the below values:

  1. Net Asset Value: $ 2,639,679
  2. Commitment: 3,000,000
  3. Less: Contributions: (2,302,493)
  4. Remaining Capital Commitment: $ 697,507

Please help on this

2

Here are the regular expressions to extract the values:

  1. Net Asset Value

regex

Net Asset Value:\s*\$?\s*([\d,]+)
  1. Commitment

regex

Commitment:\s*([\d,]+)
  1. Less: Contributions

regex

Less:\s*Contributions:\s*\(?([\d,]+)\)?
  1. Remaining Capital Commitment
Remaining Capital Commitment:\s*\$?\s*([\d,]+)

Each regex captures the numerical values while handling optional dollar signs and parentheses. Let me know if you need modifications! :blush:

4

Implementation in UiPath Assign Activity:

vb

NetAssetValue = System.Text.RegularExpressions.Regex.Match(inputString, "(?<=net asset value of \$)[\d,]+").Value
RemainingCommitment = System.Text.RegularExpressions.Regex.Match(inputString, "(?<=remaining capital commitment of \$)[\d,]+").Value
TotalCommitment = System.Text.RegularExpressions.Regex.Match(inputString, "(?<=total commitment of \$)[\d,]+").Value

These expressions will extract:

  • Net Asset Value: $2,639,679
  • Remaining Capital Commitment: $697,507
  • Total Commitment: $3,000,000
5

WHat about Commitment??
the values will be dynamic

6

Yes RegEx is always dynamic, until you handle properly your string values.

7

@naveen.s

actually if order is same then thise should do the job to match any numbr…and () generally means they are negative number can replace them once you read and consider value as negative

\(?\d{1,}[\d,]+\)?

The image shows a regular expression test interface with the expression matching four instances of comma-separated numerical values in a provided text string. (Captioned by AI)
The image shows a regular expression test interface with the expression matching four instances of comma-separated numerical values in a provided text string. (Captioned by AI)895×364 28.6 KB

cheers

1 Like
8

@Anil_G ,

I am using the below expression to get Net asset Value but not working:

System.Text.RegularExpressions.Regex.Match(ReadPage2, “((?\d{1,}[\d,]+)?”).Value

9

Check your String “ReadPage2” once and use it ReadPage2.trim.toString

10

(post deleted by author)

11

@naveen.s

duplicate

1 Like
12

Hi @naveen.s

What is your input data and required output data, could you please specify more to get us understandable.

13

@naveen.s

first of all check how the values look by writing the data to text file…then we can get the regex for each

cheers

16

Okay @naveen.s

You can use the below regular expressions,

  1. NetAsset Value $ 2,639,679
(?<=Net Asset Value \$\s+)[\d\,\.]+

A regex pattern is used to highlight and match the value of "Net Asset Value" in a financial statement, specifically the dollar amount $2,639,679. (Captioned by AI)
A regex pattern is used to highlight and match the value of "Net Asset Value" in a financial statement, specifically the dollar amount $2,639,679. (Captioned by AI)1375×814 90.2 KB

2.Commitment 3,000,000

(?<=Commitment \$\s+)[\d\,\.]+

The image shows a regular expression and its associated matching text highlighting the value "$697,507" within a financial statement excerpt. (Captioned by AI)
The image shows a regular expression and its associated matching text highlighting the value "$697,507" within a financial statement excerpt. (Captioned by AI)1375×812 89.3 KB

  1. Less: Contributions (2,302,493)
(?<=Less: Contributions\s*)[\(\)\d\,\.]+

The image shows a regular expression tool highlighting a match for a financial figure, specifically the value "(2,302,493)" under the item "Less: Contributions" in a financial statement. (Captioned by AI)
The image shows a regular expression tool highlighting a match for a financial figure, specifically the value "(2,302,493)" under the item "Less: Contributions" in a financial statement. (Captioned by AI)1374×804 89.6 KB

  1. Remaining Capital Commitment $ 697,507
(?<=Remaining Capital Commitment \$\s*)[\d\,\.]+

The image shows a regular expression tool matching a numeric value for 'Remaining Capital Commitment' within a block of financial text. (Captioned by AI)
The image shows a regular expression tool matching a numeric value for 'Remaining Capital Commitment' within a block of financial text. (Captioned by AI)1375×812 91.2 KB

Hope it helps!!

17

@naveen.s

please use this

(?<=Net Asset Value *\$ *)\(?\d{1,}[\d,]+\)?

The image shows a regular expression search tool that has successfully matched the value "2,639,679" as the Net Asset Value in a text string from financial data. (Captioned by AI)
The image shows a regular expression search tool that has successfully matched the value "2,639,679" as the Net Asset Value in a text string from financial data. (Captioned by AI)931×722 63 KB

cheers

18

Hi @naveen.s

1: Net Asset value: (?<=Net Asset Value\s)$\s*[\d,]+
2: Commitment: (?<=Commitment\s)[\d,]+
3: Less: Contributions: (?<=Less: Contributions\s)[-(\d,).]+
4: Remaining Capital Commitment: (?<=Remaining Capital Commitment\s)$\s*[\d,]+

Thanks!!

19

@naveen.s , please always sanitise the data before publishing online. I think you just published financial information of a member of a royal family. Either you or your employer could end up having to face the legal system.

20

(?:()?\s*$?\s*([\d,]+)\s*(?:))?

try this