Unanswered

How to extract text from a variabl?

(0) Share

Report

Posted on by mktranslation

Hi All!

Can someone please advice how to extract the text I need from this variable? The numbers and the amount of rows are differnent in each loop iteration. But I need the teext from rows in between row with "TASK NAME:" and "O the source" 🙂

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Looks like you are in a text variable. Split text by new line to a list variable %SplitText%.

Create List %ExtractedText%
Loop 0 to %SplitText.Count - 1% increment of 1
Get Subtext %SplitText[LoopIndex]% from start to 10 - Save as %SubText%
If %SubText% equals “TASK NAME”
Set %CurrentExtract% to %SplitText[LoopIndex + 1]%
Add %CurrentExtract% to List %ExtractedText%
End(If)
End(Loop)

Now all your extracted texts are in a list in the same order that you processed each iteration of combing through the texts.

Was this reply helpful? Yes No
UK_Mike on at

Like
a
(0)

Report
Copy link

Link copied!

I could have sworn that regex was the way to go on this one but thats just opened up endless possibilities for me.
Reading Pdfs with regex is great but needs a separate regex per pdf.
This just needs the vars editing, am I right in thinking this ?

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Right. So, regex would be faster too, cuz this is a lot of steps for the bot to take. Unfortunately, I don’t know regex and have only used it a handful of times. Fortunately, Task Name looks to be only about 18 lines down, so it shouldn’t be too bad. You would have outer loop around everything I gave you to run through each document, Like:

Get Files
Create List %ExtractedText%
Loop 0 to %Files.Count - 1%
-Do everything that I gave you last time except Create List, cuz that needs to happen outside of the Loops.
End Loop

Was this reply helpful? Yes No
UK_Mike on at

Like
a
(0)

Report
Copy link

Link copied!

Going to have a play around with this, thanks.

Was this reply helpful? Yes No