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.

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 [image] Bosch: More than three consecutive sample did…

How to check the item of List is continuous?

Help Studio

ppr (Peter Preuss) October 12, 2021, 1:06pm 9

it is LINQ code

1 Like

Topic		Replies	Views
C#: How to get the next row item and compare it with current row item? Using For each Excel Row Studio excel , uiautomation , studio , question , activities_panel	4	576	February 2, 2023
How to check the next item when using for each row Activities uiautomation , activities , question	6	2256	January 30, 2022
From a list of strings to get the count of similar items Activities datatable , excel , uiautomation , orchestrator , activities , studio , studiox , question , linq , list , linq-query , linq-quey , datetime-linq , linq-loop , datelime-linq	5	906	January 11, 2023
Comparing consecutive item values in a Matches variable? Help activities , question , data_manipulation	10	1421	January 15, 2020
How to continue counting from the last previous item in For Each loop after placing Break activity? Help	20	4347	January 2, 2019

How to check the item of List is continuous?

Related topics