cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ed11
Frequent Visitor

PDF to text, now what?

I'm able to convert my PDF and save it to a text file.  Now I need to only select certain items in the text file for use.  I have no idea how to do this.  

 

The PDF comes in from a mortgage originator.  It has lots of info but I only need a few specific items so that I can plug it into my real estate software.  Things like Borrower 1 first and last name, address, loan amount, etc.  I don't need the whole form.  How can I do this?

1 REPLY 1
eric-cheng
Solution Sage
Solution Sage

Hi @Ed11 ,

 

If you are using OCR which will literally take a word dump of your PDF into text.  To extract a key piece of information out, there isn't an easy way apart from using some type of string manipulation.  You would usually go through each line, look at the piece of text before and after and try to ascertain the position and whether it is your text.

 

You should also look at AI builder which will allow you to build and train a model against a PDF and extract tabular and key value pairs.  This way, you don't need to do all of the above.  Please have a look at this link to see if it can help.

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,246)