Need to extract only months

Help Activities
, ,
1

Hi Team, I have to extract months count from the below text could you please help on this?.
Input: Extend Contract : 12 months; Reinstate Contracts: 261223999; effective : 09-24-2024.

Output: 12

2

Hi @manojmanu.rpa

Try this

(\d+)(?=\s+months)

The image shows a regular expression tool where the expression is successfully matching the number "12" in the input text "Extend Contract: 12 months; Reinstate Contracts: 261223999; effective: 09-24-2024." (Captioned by AI)
The image shows a regular expression tool where the expression is successfully matching the number "12" in the input text "Extend Contract: 12 months; Reinstate Contracts: 261223999; effective: 09-24-2024." (Captioned by AI)1434×436 18.2 KB

Or

(?<=Extend Contract\s+:\s+)(\d+)(?=\s+months)

This image shows a regular expression that successfully matches the number "12" in the text "Extend Contract: 12 months; Reinstate Contracts: 261223999; effective: 09-24-2024." (Captioned by AI)
This image shows a regular expression that successfully matches the number "12" in the text "Extend Contract: 12 months; Reinstate Contracts: 261223999; effective: 09-24-2024." (Captioned by AI)1433×469 20 KB

Regards,

3

@manojmanu.rpa

System.Text.RegularExpressions.Regex.Match(Input,"(\d+)(?=\s+months)").Value

The image shows a UiPath automation sequence that assigns a string "Extend Contract : 12 r" to an "Input" variable, extracts a number "12" using regular expressions into an "Output" variable, and then displays the "Output" variable in a message box. (Captioned by AI)
The image shows a UiPath automation sequence that assigns a string "Extend Contract : 12 r" to an "Input" variable, extracts a number "12" using regular expressions into an "Output" variable, and then displays the "Output" variable in a message box. (Captioned by AI)872×589 19.2 KB

Regards,

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.