Need Extract NotePad by search Number

Help Something Else
, , , , ,
1

I need to extract specific Company Name, Company ID, Recv DFI
If I search Trace Number

Like if I search 00000000000002 in notepad . I want Company Name, Company ID, Recv DFI from that row
New Text Document.txt (991 Bytes)

2

Hi @Sayed_Tabrez2 ,
Option 1:
check is there any possibility to convert the text to data table, so that you can get the value easily.
Option 2:
you can go with regex to identify the company name in which line, based on the line you can again do the regex/split mechanism to extract all the values.

Regards,
Arivu

1 Like
3

please , Can you try to code with option 2.

4

using generate data table activity convert the txt into table. then u can remove rows using if condition to remove the headers from each line in the txt. Then from excel you can fetch the particular value based on the ID u mention

5

Data tables is Not in the prefect format. Any Other Option?

6

can u able to read the text file as CSV?

7

yes, I Can Convert But Headers are mismatching

8

u can create build data table and fix the headers. then after reading csv you will get datatable. from that loop the table and remove the row based on the condition that isnot numeric(currentrow(0).tostring). so that header rows will be removed. after loop first write the build DT and then use append range the values of CSV table

9

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