Linq SelectMany ListofDictionary

[wonderingnoname]

Hello!

I have a

List<Dictionary<string, string>>

the dictionary consists of mail details, example:
{
[“name”] = “Adam”,
[“mail”] = “abc@abc.com”
[“subject”] = “test 123”
}
{
[“name”] = “Deo”,
[“mail”] = “abcd@abc.com”
[“subject”] = “test email”
}

I would like to use LINQ to get all subject that contains number. I found some examples using datatable but not in list of dictionary.

Thanks!

[Yoichi]

Hi,

Can you try the following expression?

subjects = listDict.Select(Function(d) d("subject")).Where(Function(s) System.Text.RegularExpressions.Regex.IsMatch(s,"\d")).ToArray()

Main.xaml (6.8 KB)

Regards,

[wonderingnoname]

@Yoichi

listDict.Select(Function(d) d("subject")).Where(Function(s) System.Text.RegularExpressions.Regex.IsMatch(s,"\d")).ToArray

This worked! Thanks a lot!