Read text file and get value to excel

Help
,
1

I want to read text file and send value to excel.

Example.

IN
AARTFSEFTRE01881 waiting for 4 days
Count: 1
Error: Client
AARTFSEERRE01881 waiting for 2 days
Count: 1
Error: TYPE

If find error = Client
read before row and get word before waiting for (AARTFSEFTRE01881)

Please guide me about it.

2

@fairymemay How do you want the output in Excel to appear ?

3

Hi please check how to get that Word and make changes as per your need
test.txt (124 Bytes)
textfile.xaml (9.8 KB)

4

I have more question.
If I want to change condition from Error: Client to except Error : Client

Please guide me about it.

5

change it in condition then
Is it worked above one?

6

I want to change condition from Error: Client to other error (except Error: Client)

image

image

7

is “except Error: Client” or you want other than “Error: Client”

8

except Error: Client

9

means which does not contains this Error: Client ryt ?
if yes then use Not before condition

10

right?
image

11

Yes this will check for txt data which not contains that string