cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Berna
New Member

extract specific text from a text file

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Berna :

Please try this:

vbofengmsft_0-1626057978502.png

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

The Result:

vbofengmsft_1-1626058008167.png

Best Regards,

Bof

 

View solution in original post

4 REPLIES 4
v-bofeng-msft
Community Support
Community Support

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:

vbofengmsft_2-1625711022032.png

Pattern:

 

ERROR: \S+ \S+

 

The Result:

vbofengmsft_1-1625710956643.png

Best Regards,

Bof

Berna
New Member

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.

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:

 

Berna_0-1625946837916.png

 

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.

Hi @Berna :

Please try this:

vbofengmsft_0-1626057978502.png

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

The Result:

vbofengmsft_1-1626058008167.png

Best Regards,

Bof

 

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,238)