I am extracting data using data scrapping method from a website and storing in var Dt. For each row in dt i need to compare the street No with a VarA. Eg: VarA contains number 20, the row in Dt always starts with the street No Eg: 20 street limer Australia 3207. How do i write the code. Also the row in dt can also be eg: 10-30 street limer Australia 3207. In such cases how do i write the code.
@RACHEL_PAUL , it would be helpful for us to find a solution if you can explain how 20 can also be represented as 10-30 in the address. Is there some specific criteria?
@RACHEL_PAUL ,
Yes if your VarA is 10 then According to the code it will retrieve the first 2 digits from the currentrow by doing Left(CurrentRow("Address").ToString,2) which will return value as 10
then using if condition both the values will match .
I am supoosed to find the addresses. So there is a possibility that the street no and the VarA will be the same or if street No will be in range that is (eg: 10-30) so if Var A that is (eg:20) is found between the range i need to consider that address.
Before using the above expression, use a if condition and check the count is greater than 0, else it will throw error if there are no rows to copy to datatable: