Loop through entire row and check if string contains specific word

Help Studio
, , , ,
1

I have a list of full address in sheet 1 and list of all the province in sheet 2.
What I want is to loop through the entire row of address then checks if the address contains a specific province from my list then write that province besides the address.

  1. First I read the range of the address and province and store in data table

image

  1. Then I loop through province row using for each row data table and assign it to “sample” variable

image

  1. After that I loop through the address row and checks if my address contains a province in my list

Like this:

CurrentRowData.Item(“Address”).ToString.Contains(sample).Equals(True)

image
image626×584 18.8 KB

The problem is, it doesn’t give me the result I want.

2

@Shoji welcome to the Comunity

VariableName.Rows.Contains(“SpecificContent”)

image

3

I provided some images, can you look at it again? thanks

4

Hi,

I think it’s necessary to consist of double loop as the following. Can you try this?

image

Regards,

5

Hello, thanks for the comment. I tried it but it doesn’t satisfy my condition.

6

@Shoji

try this once

CurrentRow.Item(“Address”).ToString.Contains(“sample”) = True

7

Hi,

If I understood your requirement correctly, the following mock sample will work. Can you try this?

image
image825×1164 32.2 KB

Sample20230205-3L.zip (3.1 KB)

Regards,

8

Hello, it’s the same result

9

image
image1255×518 28.7 KB 

CurrentRow.Item("Address").ToString.Contains(CurrentRow.Item("Province").ToString.Trim) = True
1 Like
10

Thank you, this is the output I’m looking for.

1 Like
11

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