LookUp Data Table Showing Null

Help Activities
, ,
1

Hi,

I want to lookup the Value which i scrapped from website.

Assume it is “Rishi”

But in my excel all the values contains spaces ex- "Rishi "

So lookup data table is showing error because of this space. Is there any way to do…?

Thanks,
Rishi

2

Hi @Rishik_Chowdary

you can “Trim” the value after Scraping and then use to write in the Excel.

Thanks.

3

Hi @suraj.setty

I have to compare the scrapped the value is present in Excel or not…!!

I was not writing any thing in excel… but excel contains spaces…!!

1 Like
4

Hey @Rishik_Chowdary

Just add a space at the end,

str_LookupValue + " "

Thanks
#nK

1 Like
5

Thanks Nithin… Now It is working

marked as solution …!!

1 Like
6

Cool @Rishik_Chowdary :slightly_smiling_face::+1:

7

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