Contains

I have a cell in excel that contains tm9898. When i search 9898 using lookup it wont be found. How can i go around for look up to search 9898 even if it have tm at first.

2 Likes

Buddy we can use a if condition before getting the lookup value of tm9898
like this in if conditin
row(1).ToString.Contains(“9898”)
if this condition gets passed it will go to THEN part of if condition where we can have our lookup datatable activity and get the target value of lookup value tm9898

Cheers @Tapiwa

@Tapiwa

Have you tried with Lookup Data Table activity. If not then try it.

1 Like

Im using lookup datatable. But it wont find 9898 when there is a cell that has tm9898

Hey buddy. This would be in a for each for row item to be used

1 Like

Buddy kindly follow the below steps that could help you
–use a read range activity within excel application scope and get the output variable named out_dt of type datatable
–then use a for each row loop and pass the above variable as input to the loop
–inside the for each row loop use a if condition and mention the condition as
row(“Columnname”).ToString.Contains(“9898”)
–if this condition passes it will go to THEN part of if condition where we can use LOOKUP DATATABLE ACTIVITY and mention like this buddy

Cheers @Tapiwa

@Tapiwa

Ok. What you want to achieve with this after finding “9898”.

We can use LINQ query also but you tell me what you want to do after finding it.

were you able to get now buddy @Tapiwa

Thanks buddy. it worked.
Cheers @Palaniyappan

1 Like

Fantastic buddy
Cheers @Tapiwa