LINQ query on Generic List

Help
1

Hi Everyone,

I am having below generic list,

TestList = New List(of string)(new String(){“QUS0031056PR19A”,“US00073718PR20A”,“QHK0016342CA19A”})

Using LINQ, I want to get all strings in an another list which are of type xUSxxxxxxxxx19x. The first element in above list(QUS0031056PR19A) satisfy this pattern. It should be noted that all element are of same length(15 characters).

Any help on this request would be much appreciated.

2

@Kapil Check this Expression :

testList.Where(Function(x)Regex.IsMatch(x.Trim,".US.{9}19.")).ToList
2 Likes
3

grafik
grafik944×67 21.9 KB

1 Like
4

Thanks!! Its working

1 Like
5

Thanks! Its working

6

Hi @supermanPunch,

There is an update in requirement now. Instead of 19 in the pattern xUSxxxxxxxxx19x, I need to filter all string whose value is less than 19, like xUSxxxxxxxxx18x, xUSxxxxxxxxx17x, xUSxxxxxxxxx16x etc.

Is it possible to create linq query for this?

7

hi @ppr

There is an update in requirement now. Instead of 19 in the pattern xUSxxxxxxxxx19x, I need to filter all string whose value is less than 19, like xUSxxxxxxxxx18x, xUSxxxxxxxxx17x, xUSxxxxxxxxx16x etc.

Is it possible to create linq query for this?

8

@Kapil Check this Expression :

testList.Where(Function(x)Regex.IsMatch(x.Trim,".US.{9}[01][0-9].")).ToList
4 Likes
9

@Kapil

Great solution for this @supermanPunch! However i encountered that the value 19 is still included, but the question was less than 19.

Regex2
Regex21898×300 22.7 KB

I changed your solution a bit so that the 19 isn’t included anymore.

Regex1
Regex11880×292 26.1 KB

So the whole statement is

testList.Where(Function(x)Regex.IsMatch(x.Trim,".US.{9}(([01][0-8])|09).")).ToList

Best regards

Leo

4 Likes
10

Thanks everyone for your help!!!

3 Likes