Check text contain?

Help Activities
, ,
1

I want to check text contain.

example r(“SR Detail Wording”) = “test Now”
SR_DetailWording = “check TestNow****”

I want check SR_DetailWording is contain in r(“SR Detail Wording”) or not
Now I have code as below.

If(masterDt.AsEnumerable().Any(Function(r) r("Category").ToString().Trim = srCategory AndAlso 
										   r("SR Detail Wording").ToString().Trim = SR_DetailWording), "Y", "N")

Please guide me for solve it.

2

Hi @fairymemay

Try this:

If masterDt.AsEnumerable().Any(Function(r) r("Category").ToString().Trim() = srCategory AndAlso
                                           r("SR Detail Wording").ToString().Trim().Contains(SR_DetailWording), "Y", "N")

Hope it helps!!

3

@parvathy now error as below.

image
image1255×212 14.7 KB

4

Can you try following

If (masterDt.AsEnumerable().Any(Function(r) r("Category").ToString().Trim() = srCategory AndAlso
                                           r("SR Detail Wording").ToString().Trim().Contains(SR_DetailWording)), "Y", "N")
5

Hi @fairymemay

Try this:

If(masterDt.AsEnumerable().Any(Function(r) r("Category").ToString().Trim() = srCategory AndAlso r("SR Detail Wording").ToString().Trim().Contains(SR_DetailWording)), "Y", "N")

Hope it heps!!

6

@parvathy I think condition as wrong.

Now
r(“SR Detail Wording”).ToString().Trim().Contains(SR_DetailWording))

I think true should be.

SR_DetailWording contain r(“SR Detail Wording”).ToString

But I don’t know how to write code?

7

Hi @fairymemay

Try this:

result = If(masterDt.AsEnumerable().Any(Function(r) r("Category").ToString().Trim() = srCategory AndAlso SR_DetailWording.IndexOf(r("SR Detail Wording").ToString().Trim(), StringComparison.OrdinalIgnoreCase) >= 0), "Y", "N")

Hope it helps!!

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.