Not able to extract the data using regex

[Jitendra_Saroj]

I wanted to extract the number of PHDs and Number of Masters but not able to extract from all samples. anyone please tell me what is the regex for this ??

Sample 1: Our net profit after tax last year was $50,000 dollars, an increase of 12% over the previous year. The company has more than 30 PhD and about 60 master employees. The company’s operating revenue was $300,000 dollars last year.

Sample 2: The operating income of our company last year was $306,000 dollars, and the net profit after tax was $66,000 dollars, 20% higher than the previous year. The company has 50 people with master degree and about 25 people with PhD degree.

Sample 3: The company has more than 20 PhD and 40 masters. The operating revenue of the company in 2020 is more than 35 million dollars, and the net profit after tax is 1 million dollars, which is 15% lower than the previous year.

Sample 4: The company’s operating revenue in the previous year was $807,000 dollars, and the net profit after tax was $400,000 dollars, which was 10% lower than the previous year. The company has about 60 masters and 20 PhD.

Sample 5: Our net profit after tax was over $325,000 dollars, an increase of 30% over the previous year. Last year’s operating income is more than $806,700 dollars, the company has about 35 PhD and 70 master.

Sample 6: Our net profit after tax last year was $8,203,100 dollars, an increase of 25% over the previous year. The company has more than 35 PhD and about 50 master employees. The company’s operating revenue was $31,234,567 dollars last year.

[Yoichi]

Hi,

Can you try the following pattern?

PhD

System.Text.RegularExpressions.Regex.Matches(yourString,"\d+(?=\s+(people with\s+)?PhD)")

master

System.Text.RegularExpressions.Regex.Matches(yourString,"\d+(?=\s+(people with\s+)?master)")

Sample20221209-3.zip (2.9 KB)

Regards,

[Gokul001 (Gokul Balaji)]

Hi @Jitendra_Saroj

Welcome to UiPath community

Check out this expression

This will get only the PhD degrees count

System.Text.RegularExpressions.Regex.Match(YourString,"\d*[0-9](?= PhD)|[0-9]*\s(?=people with PhD degree)").Tostring

This will get only the Master degrees count

System.Text.RegularExpressions.Regex.Match(YourString,"\d*[0-9](?= master)|[0-9]*\s(?=people with master degree)").Tostring

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Hi @Jitendra_Saroj

Check out the XAML file

MatchesRegex1.xaml (17.7 KB)

Regards
Gokul

[Jitendra_Saroj]

@Yoichi

\d+(?=\s+(people with\s+)?master)

Thanks , Its working fine

[Jitendra_Saroj]

Thanks, its working