extract specific text from a text file

Like (0) Share

Report

Posted on 8 Jul 2021 00:21:08 by Berna

Hello everybody.

I have a text file that says the following:

xxxx ERROR: wrong date1 xxxxxxxxx ERROR: wrong date2 ERROR: wrong date 3

I need you to analyze the text and copy the following into a file:

ERROR: wrong date1
ERROR: wrong date2
ERROR: wrong date3

That is, the flow should look for every "error:" and copy the message below every time it occurs.

Can you help me, please.

Thank you.

All responses (4)

Answers (1)

Verified answer

v-bofeng-msft on 12 Jul 2021 at 02:46:57

Like (0)

Report
Re: extract specific text from a text file

Hi @Berna :

Please try this:

(?<=000)[a-zA-Z :.]*ERROR[a-zA-Z0-9 :.]*

The Result:

Best Regards,

Bof
Berna 4 on 10 Jul 2021 at 19:57:07

Like (0)

Report

Re: extract specific text from a text file

Hi how are you?
I've been looking at the solution you gave me but I can't quite understand it.
Below I put a screenshot of the actual text file:

What I need is for you to put all the errors you find in a file. The error can be identified by the word "ERROR CODE:"
This is the text:
D 3100002606 MINISTRY OF SECURITY 63,840.00 001 001 52 $ 00140999800001420001721307 2021/07/07 R
000 ERROR CODE: 206 ERROR DESC: INVALID CREDIT CBU
I would need the result to be the following:
ERROR CODE: 206 ERROR DESC: INVALID CREDIT CBU
I also take the opportunity to ask you where I can learn the meaning of the "\ S +" commands and the like.
Thanks so much for the help.
Berna 4 on 08 Jul 2021 at 18:33:45

Like (0)

Report

Re: extract specific text from a text file

ah you are a genius. Let me check this and I'll write you back.

I'm new in Power automate but I love it.

Sorry my English.

Berna.
v-bofeng-msft on 08 Jul 2021 at 02:28:00

Like (0)

Report
Re: extract specific text from a text file

Hi @Berna :

Could you describe in detail the demo of the text you provided.

Is there a separator between the two errors? How to tell what is "wrong date" and what is the name of error?

At present, I can only analyze the demo you provided and get the results.
My parsing logic is to retrieve all text that meets the following positive expression:

ERROR: \S+ \S+

I've made a test for you reference:

Pattern:

ERROR: \S+ \S+

The Result:

Best Regards,

Bof