You’re offline. This is a read only version of the page.
Announcements
39
There is a task of searching for variables in a text file.
The text file has the following contents:
Example
Sectiondocument=Payment order
Payer= Example
Payer's account= Example2
Payer's bank = Example3
Payee's account= Example4
Published data= 27/10/2021
Recipient = Example5
Payment type= electronic
Payment type =01
Purpose of payment = Example6
End of the document
Sectiondocument=Payment order
Payer= Example11
Payer's account = Example22
Payer's bank = Example33
Payee's account = Example 44
Published data= 27/10/2021
Recipient = Example55
Payment type= electronic
Payment type =01
Purpose of payment = Example66
End of the document
Sectiondocument=Payment order
Payer= Example111
Payer's account= Example222
Payer's bank= Example333
Payee's account= Example444
Published data= 27/10/2021
Recipient = Example555
Payment type= electronic
Payment type =01
Purpose of payment = Example666
End of the document
End of File
It is necessary to select all the values of "Payer=" from this text file.
But I ran into a problem, I find the first value, and then I don't understand how to continue (loop) the search?
To search, I use a flow of the following type:
To extract the text, I use the function:
split(split(triggerOutputs()?['body'],'Payer=')[1],'Payer's account=')[0]
Next, I write the search results to a table on sharepoint.
I find the first value(Example), and then I don't understand how to continue (loop) the search next value(Example11,Example111)?
Tell me what needs to be adjusted in the PA flow to make a loop search through a text file all values?
For this I wouldn't use a loop. I would Split() the text file on a carriage return to convert it to an array of lines. Then do a filter array action on it to find the lines that start with 'Payer='. That will give you an array of the lines that match that criteria.
Share
Report
All responses (
Answers (
