How do I divide the given numbers into 0-10, 10-25 and 25+

Help Activities
, ,
1

I have to insert the given numbers into application where I have only 3 options in drop down 0-10, 10-25, 25+ . I have no issue when I get number as it is in drop down, But I am facing error when I get values like 9 , 14 , 28+, 40 . Can someone help in converting the given numbers into 0-10 , 10-25, 25+

2

@Naresh_Mandava

First Get the only numbers as below

image
image1672×565 38.6 KB

Later you can keep a if condition to check whether the number is in the range of the drop down options

image
image1488×887 30.2 KB

For your understanding I placed the message boxes, you can replace that with your select option

image
image1463×871 35.4 KB

Hope this helps you

Thanks

3

@Naresh_Mandava
if numbers with a + are to check e.g. 59+ we ave to parse eg. with regex \d+ and to convert e.g. Convert.toInt32(…

For getting some flexibility we can work with a switch activity.

Variables:

grafik
grafik762×115 14.9 KB

grafik

So we define the segments within the cases similar to the defition of the arrNumbers.
arrRange.Where(Function (x) iNumber >= x ).Max() calculates for us the relevant case

Output of a test sequence:
grafik

find starter help here:
IntNo_SegmentSwitchMapper.xaml (8.8 KB)

2 Likes
4

Thanks for the help @ppr , This is working only when I get numbers but when I get input as 25+ or 10-25 this is not working.

5

Yes that is correct as it is string. It was mentioneded here:

6

@Srini84 thanks for the help, Getting only numbers is creating new problem when i have value as 10-25

7

@Naresh_Mandava

parsing the string into a number can be done by regex \d+
grafik

identifying the additional modifiers e.g. 33+ we can work with groups:
grafik

similar we can check for ranges.

Afterwards we would implement e.g. with a switch on how and what info we want to retrieve from the string for the number parsing / conversion