Extract a specific information from a text file

[Palaniyappan (Palaniyappan P)]

Hi

Hope the below steps would help you resolve this

1. Use a assign activity like this

arr_files = Directory.GetFiles(“your folderpath”)
Where arr_files is a variable of type array of string

2. Now use a BUILD DATATABLE activity and create a table structure u want which can be used to compare with the excel file u have and get the output as dt-input

3. Now use read range activity and read that excel file with datatable output named as dt

4. Use a FOR EACH activity and pass the array variable as input and change the type argument as string

5. Inside the loop use a READ TEXT FILE activity and pass the input filepath as item and get the output as stroutput

6. From this string output get the information u want and add it to the datatable built earlier with ADD DATAROW activity

7. Now you can compare the datatable read and built by ur own however u want

Have a view on this tutorial on how to use datatable

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

Cheers @imane.bousaad