Answered

Get a Value after a specific word

(0) Share

Report

Posted on by Zohaib1999

132

Hi , i have a pdf with a info with for example "Loading Reference: 12345". I just want the info next to this word "Loading: Reference:". There are random words after this word, so i can't use the action where i can filter between 2 words. any solutions?

The "word Loading Reference:" is standard.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Zohaib1999
We can achieve using many scripting languages too. But below is PAD way of doing.
Please use the actions suggested below:

Code:
Pdf.ExtractTextFromPDF.ExtractText PDFFile: $'''C:\\Users\\2440621\\Documents\\Loading.pdf''' DetectLayout: False ExtractedText=> ExtractedPDFText
Text.Trim Text: ExtractedPDFText TrimOption: Text.TrimOption.Both TrimmedText=> TrimmedText
Text.SplitText.SplitWithDelimiter Text: TrimmedText CustomDelimiter: $'''(?<=Loading Reference: )''' IsRegEx: True Result=> TextList
Display.ShowMessageDialog.ShowMessage Title: $'''Alert''' Message: TextList[1] Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed

Thanks,
Deenu

Was this reply helpful? Yes No
Zohaib1999 132 on at

Like (0)

Report
Copy link

Link copied!

It worked :), but are there some limitations? for example the next 5 letters? = 12345

Was this reply helpful? Yes No
Zohaib1999 132 on at

Like (0)

Report
Copy link

Link copied!

Or maybe till the next blank line. Would be logical in this case

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Zohaib1999

No. there is no limitations on that. It will split any text after "Loading Reference:". Hope this helps!!

Thanks,
Deenu
------------------------------------------------------------------------------------------------------------------------------
If this helps & solves your problem, please remember to give a thumbs up and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Zohaib1999
Example1:

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
You can use Parse text with regular expressions enabled and use the following as the pattern:

(?<=Loading:\sReference\s)\d+ for any number of digits after the phrase

(?<=Loading:\sReference\s)\d{5} for 5 digits after the phrase

(?<=Loading:\sReference\s)[^\s]+ for any number of non-whitespace characters after the phrase

Plenty of other possible combinations, too.

The action should look like this:

You put the regular expression into the "Text to find" field, and enable the "Is regular expression" toggle. The output will then be stored in the variable called %Match%.

Was this reply helpful? Yes No