Hello, I am trying to use a LINQ function to assign to variable. I have list that looks something like the list below: 25001\sample.json 25001\example.xlsx 25001\test.json 25002\example.xlsx 25002\sample.json 25002\test.xlsx I want to split each item using “\” as the delimiter and keep only …

Split list and remove duplicates

Yoichi (Yoichi) November 3, 2022, 1:43pm 4

Hi,

Can you try the following expression?

resultList = yourList.Select(Function(s) s.Split("\"c).First).Distinct().ToList()

Regards,

Topic		Replies	Views
Split & Join List using Regex Activities activities , studio , question	4	620	April 22, 2023
How to remove duplicates from IEenumrable <system.text.RegularExpressions.match> Activities pdf , activities , regex , question , ienumrable	9	2999	July 1, 2021
Trim a list Help activities , question , document_processing	8	2928	January 15, 2021
Split cell values in datatable using linq Forum datatable , excel , question	3	1425	June 22, 2022
Splitting a list<string> variable into another list<string> Studio studio , string , question , activities_panel , string-manipulation	4	1261	September 8, 2022