12
Hi,
I'm reading a text file through Get File content. Is it possible to read each line and search for the keyword ERROR. ?
I want to build a loop where it reads line by line and if it finds the keyword ERROR then will proceed further in IF condition.
I tried using apply each but I'm going wrong somewhere!
Eg. This sample file has 3 rows with ERROR keyword so the loop will enter the IF case 3 times where I can do other actions.
Regards,
Pranav
Just as an additional note, in some Windows text files each line could end with two characters: a Carriage Return (CR) and Line Feed (LF) characters:
You can use apps such as NotePad++ to view these characters.
So the file could also be split at the CRLF characters:
Share
Report
All responses (
Answers (
split(body('Get_file_content'),decodeUriComponent('%0D%0A'))
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
You can use function split() to split the file content at line breaks.
Line break is decodeUriComponent('%0A')
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
