Extract Specific Text from a Bank Statement from PDF to Excel

Like (0) Share

Report

Posted on 29 Jan 2024 01:13:18 by lizzy1994

I'm doing a flow where I extract the first sheet of a pdf file and then I use the Analyze Text action to bring in only the text I want but when I run it doesn't bring me the information. in parse text in "text to search" Current Balance (. +) and in the pdf file what I need is to look for the numerical value that is after current balance which is shown like this: $ 123.876.335.89 do you know how I can place the expression to store the balance in the variable?

prueba.zip

All responses (1)

Answers (0)

UshaJyothiKasibhotla 63 Moderator on 29 Jan 2024 at 01:40:45

Like (0)

Report

Re: Extract Specific Text from a Bank Statement from PDF to Excel

Use regex pattern
In text to search in parse text activity
(?<=current balance).*

And in the variables produced match will be the variable which stores the required value.

Hope this helps
Usha