extract specific text from a text file

(0) Share

Report

Posted on 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.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-bofeng-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
Berna 4 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Berna 4 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @Berna :

Please try this:

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

The Result:

Best Regards,

Bof

Was this reply helpful? Yes No