How to arrange ages in ascending order dynamically

[anjani_priya]

How to arrange ages in ascending order dynamically 0-30 181-365 31-60 365-700 91-180
in this format.

[ashokkarale]

@anjani_priya,

Try modifying this code

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

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 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 l…

[prashant1603765 (Prashant Kumar)]

Hi @anjani_priya

Input = New List(Of String) From {“0-30”, “181-365”, “31-60”, “365-700”, “91-180”}

Order = Input.OrderBy(Function(range) Convert.ToInt32(range.Split("-"c)(0))).ToList()

Output = String.Join(“,”, Order)

---

If you found helpful, feel free to tick as a solution.
Happy Automation

[anjani_priya]

Column data should also change the index

[prashant1603765 (Prashant Kumar)]

@anjani_priya

Yes, since the data is now sorted in ascending order, the index positions have changed accordingly. If the index is being used for any reference or mapping, it should be updated to match the new order.

Happy Automation

[Anil_G (Anil Gorthi)]

@anjani_priya

Please try this

Say you are getting a string in the above given format

Str.split(" "c).OrderBy(function(x) cint(x.split("-"c).First)).Toarray this will give array of strings in ascending order

Cheers