How to filter the Age less than 180 where age is in range format like 0-30,31-60,61-90,91-180, so on

Help Automation Ops
,
1

How to filter the Age less than 180 where age is in range format like 0-30,31-60,61-90,91-180,181-365,366-730,>730,not due

2

Hi @anjani_priya ,
can you provide the sample input and expected output.

Regards,
Arivu

3

Hi @anjani_priya ,

Could you please provide some more context to look into it please?. Thanks!

4

Hi @anjani_priya
Assumption: you are comparing with 180 or any of the Upper Limit in the range input.

Here is one approach:

The image depicts a flowchart of a conditional logic process involving assigning and evaluating the variable "lowerAge". (Captioned by AI)
The image depicts a flowchart of a conditional logic process involving assigning and evaluating the variable "lowerAge". (Captioned by AI)696×673 20.2 KB

The Logic:
Step 1: Using Regex, extract the lower limit of the Age. (extracting the Higher limit will work in cases “<=”, “>=” and “>” 180, Because you mentioned only “less than” and not “less than equal”, i must take the lower limit otherwise it’ll fail for input 91-180)

lowerAge = System.Text.RegularExpressions.Regex.Match(inputAge, "\d{1,3}(?=-)|(?<=>)\d{1,3}").Value

Step 2: Using the following “Else If” logic, we will handle the cases for “<180”, “>180” and “not due”:

If Not String.IsNullOrEmpty(lowerAge) AndAlso CInt(lowerAge) < 180, then:
     '''Your process for <180'''
Else If Not String.IsNullOrEmpty(lowerAge) AndAlso CInt(lowerAge) > 180, Then
    '''Your Process for >180'''
Else
    '''Your Process for No Due'''

The “AndAlso” is used to handle the empty string returned by regex for the “no due” cases.

The Output:
Case 1:
image
Case 2:
image
Case 3:
image
Case 4:
image
Case 5:
image

If this solves your issue, do mark it as a solution
Happy Automation :star_struck:

5

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