Extracting Data From Notepad(txt) File


I want to extract the below data from notepad(txt file) and paste or append in to excel file.

Below highlighted yellow colour need to extract.



Hello @Rishik_Chowdary

Is this format static?? Then you can read the text file then use split activity to split the string… you can use SlNo and F3 to get the required data… Then use Text to Datatable activity and write the output Datatable to excel


Use “read text file” activity.


Share the notepad file if possible.

Hi @Rishik_Chowdary

Use Regex code to extract the data from txt file,
and then you can store it into a data table
look into this activity

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