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.
Solved! Go to Solution.
Hi @Berna :
Could you describe in detail the demo of the text you provided.
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:
ERROR: \S+ \S+
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.