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

[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…