
Announcements
Dear Sir,
I'm trying to find a specific whole sentence in a txt file that being uploaded in sharepoint (without using any trim function) by using a word.
for example find a sentence that have ABCD, but just select one sentence so that this ABCD could be updated in sharepoint
2022-11-28 16:27:46 FORCE ABCD datalinkCmd {downlink 01032001010getre000000132AEAEC2A}
2022-11-28 16:27:48 FORCE ABCD datalinkCmd {downlink 010587684654787867437530000132AEAEC2A}
Thanks
You could parse through each line one by one using the take function
Solved: Sliting multiple lines - Power Platform Community (microsoft.com)
You could then loop through the array (which consists of each single line) and use the expression sub(length(split(variables('Single Line'),'ABCD')), 1). If it returns non zero value it confirms that the line contains ABCD