Extracting Data From Notepad(txt) File

Hi,

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.

image

Thanks,
Rishi

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

@Rishik_Chowdary

Use “read text file” activity.

@Rishik_Chowdary

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
Or
look into this activity
https://docs.uipath.com/activities/docs/generate-data-table

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