Split list and remove duplicates

[symilawr (Lawrence Symington)]

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 the first element. Using the input list above, I am trying to get the following output below:
25001
25002

Any help is appreciated.

Regards,
symilawr

[Gokul001 (Gokul Balaji)]

Hi @symilawr

You can try with Regex expression ?

System.Text.RegularExpressions.Regex.Match(YourString,"\d.*(?=\\)").Tostring

Regards
Gokul

[Gokul001 (Gokul Balaji)]

HI @symilawr

You can try with split expression also

Split("25001\sample.json","\")(0)

Regards
Gokul

[Yoichi]

Hi,

Can you try the following expression?

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

Regards,