How to extract one data from a mhl file and search this data in an excel file?

[aisharpa (Aisha)]

Hello,
I want to extract one data from a mhl file and search this data in an excel file. If it exists, I want to reply to the email.

I would appreciate any help.

[Rahul_Unnikrishnan]

Hello @aisharpa

Welcome to the UiPath community…!

Are you trying to search in a particular column?

What you can do is, use the Read range activity to read the excel and get the result to a datatable variable. Then you can use the Filter datatable activity. There you can provide the value from the mhl file and the column to check.

If the output datatable row count is greather than 0, then the value is present. Else you can loop lookup activity as well.

Thanks

[mahmoud.zaky]

@aisharpa

mhl

Hi @aisharpa,
I think you can open .mhl file using read text activity and output will be string then you can manipulate String - can find manipulation examples in below link - then you can read excel sheet and output will be data table and you can search in datatable using also way in below link.

1- String Manipulation:

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi, if you are a beginner in the world of automation and would like to know how you can manipulate text based on the solutions available in the VB.NET code and using REGEX (regular expressions) then you are in the right place. In the topic below, you will learn how to easily extract data from any part of the search text using various methods. The topic includes solution examples with descriptions and graphics to better understand the topic for functions such as: Split Substring Left Right R…

2- Search Data Table:

How to check particular string in a datatable

Hi Let’s make it in a simple method of using AsEnumerable if you have a datatable named dt Use a IF activity like this with a condition dt.AsEnumerable().Where(Function(a) a.Field(of String)(“yourcolumnname”).ToString.ToUpper.Contains(“MD/GEC”) OR a.Field(of String)(“yourcolumnname”).ToString.ToUpper.Contains(“GEC”)).CopyToDatatable().Rows.Count > 0 If it’s true it goes to THEN block which means there are records with those texts So send mail to one mail I’d Or goes to ELSE block where sen…