If string belong to a list

Help
1

I every one, I’m trying to do something but I don’t know how I can process.

I would like first to create a list. This : {A,B,C,D,E,F,G,H…}

Second part, il would like to know if a substring (row(“Column”).toString.Substring(6,1) belong to the list.

Last part, I would like to know what the lettre the most uppermost? (A<B<C<D…)

Thank you so much for your help, I’m struggling with that !!

2

Fine to check whether a element is there in list or
Not this expressions would help you
Yourlistvariable.Contains(row(“Column”).ToString.Substring(6,1).ToUpper)
This can be used in a IF condition to check whether the list has that element or not

Cheers @BaptisteC

1 Like