Alternative for Contains Keyword

Help Studio
, ,
1

Hi,
I have one excel that I’m going to upload it into orchestrator queue:

A spreadsheet displays an ID, name, and place columns, listing 4 individuals with their respective places. (Captioned by AI)
A spreadsheet displays an ID, name, and place columns, listing 4 individuals with their respective places. (Captioned by AI)1920×2560 1010 KB

Then I wanted to check in the column “place” if it has a value “pune” or not.

We can do this with Contains keyword but is there any alternative way to do this?

Thanks in advance

2

Hi @Nisha_K21

Can you try this

FinalDT = InputDT.AsEnumerable().Where(Function(row) row("Place").ToString.Split(","c).Any(Function(place) place.Trim().Equals("pune", StringComparison.OrdinalIgnoreCase))).CopyToDataTable

Regards,

3

@lrtetala ,
Suppose if these data is placed in orchestrator queue, How can I validate that?

4

@Nisha_K21

isPunePresent = in_TransactionItem.SpecificContent(“Place”).ToString.Split(","c).Any(Function(place) place.Trim().Equals(“pune”, StringComparison.OrdinalIgnoreCase))

If isPunePresent
’ Pune is present
Else
’ Pune is not present
End If

Regards,

5

@lrtetala Thanks for the response

Is it possible to do that without using LINQ?

6

Hi @Nisha_K21

You can try this way without Linq,

in_TransactionItem.SpecificContent("place").ToString.Trim.ToUpper.Contains("PUNE")

image

Regards,
Gowtham K

7

@Gowtham_K115 ,

I tried this method it worked but I wanted to check with alternative of contains keyword.

Do we have alternative method for this?

8

@Nisha_K21

Array_Place = in_TransactionItem.SpecificContent(“Place”).ToString.Split(","c)

For Each place In Array_Place 
    If place.Trim().Equals("pune", StringComparison.OrdinalIgnoreCase) Then
        Pune is Present
    Else
        Pune is Not Present
    End If

Regards,

9

@Nisha_K21

You can try this,

System.Text.RegularExpressions.Regex.IsMatch(in_TransactionItem.SpecificContent("place").ToString.Trim.ToUpper, "\bPUNE\b")

Regards
Gowtham K

10

You can use IndexOf method and check if is result is >= 0. Why don’t you like Contains though? It’s the best for this case.