How to check the item of List is continuous?

Help Studio
,
1

Hello,

I have a List of String. For example：“A111,A112,A113,A116,A117,A119”
How to get a new List like as “A111-A113,A116-A117,A119”?

Thank you.

2

Welcome to the UiPath Forum

You can use a for loop and check if the current item is the successor of the previous element, and is not tout can create the range from starting item to current item in loop

3

@Bosch
we con do it with the help of grouping the segments using a dictionary

Variables:

grafik
grafik923×134 11.9 KB

Init:
grafik

Grouping

grafik
grafik696×596 23.6 KB

Creating result
grafik

Debug/Inspections
grafik

Find starter help here:
GetRangeSegments_byStringDigitSequence.xaml (10.4 KB)

2 Likes
4

Thank you!!

This worked!

I don’t know how to express my gratitude…

5

Thank you!!
I will try this!

6

Excuse me, if I add another condition…

…=>More than three consecutive

For example：“A111,A112,A113,A116,A117,A119”
How to get a new List like as “A111-A113,A116,A117,A119”?

Thank you!!

7

Give a try on edited LINQ

ListResult =

(From kvp In dictSegments
Let doMerge = (kvp.Value.Count >= 3)
Let sgm = If(doMerge , {kvp.Value.First() & "-" & kvp.Value.Last()}.toList,kvp.Value )
Select s=sgm).SelectMany(Function (x) x).toList

sample did show 3 or more, otherwise change >=3 to >3

1 Like
8

Thank you!!

This worked!

I will try to learn RegEX~

9

it is LINQ code

1 Like
10

thx for your link
Have benefited a lot~

11

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