Filter out Data table question

[A_Learner]

Hi,
In filter datatable, I need to filter out values “S1” Or “S2” to S10. That is with one or two digits after S. Is there a way to specify this rule?

Thanks much,

[muhammedyuzuak]

Hi @A_Learner,

Could you elaborate a little more on what exactly you want to do?

Regards,
MY

[A_Learner]

Col1 has values like “ABC-S1”, “ABC-S2”, “XYZ-SEER”. So I need to remove rows with Col1 ending with “S1”, that is S and a digit.

Thank you,

[fernando_zuluaga]

Hey

did you mean something like this?

Regards!

[A_Learner]

Yes, do I have to list all S1 to S10?

Thank you,

[muhammedyuzuak]

You can use this.

[fernando_zuluaga]

do a while loop and the filter with that

FilteredDT = dt.AsEnumerable.Where(function(x) x("yourColumn").ToString.Trim.ToLower.Contains("S" + Counter.ToString)).CopyToDataTable

Regards

[A_Learner]

Thank you!! @fernando_zuluaga

[A_Learner]

But I need to eliminate these rows.

[fernando_zuluaga]

FilteredDT = dt.AsEnumerable.Where(function(x) Not(x("yourColumn").ToString.Trim.ToLower.Contains("S" + Counter.ToString))).CopyToDataTable

[muhammedyuzuak]

add “not” at the end of the function

[A_Learner]

Got it! Thanks @fernando_zuluaga, @muhammedyuzuak