How to Extract PDF particular columns data from Table?

Hi everyone,

I have some bank statements from that statements table i want to extract columns like Debit and Credit.


How can i extract and put them into Excel?
can anyone Help me

thanks in advance
krishnareddy

I would recommend writing your own custom extractor that would:

  • search for the work “Debit” (or variations thereof)
  • search for the first sentence under the table (or variations thereof)
  • find all items aligned with “Debit” and consider them values.

This would indeed need writing your own logic in a custom activity. How to do this can be found in the IntelligentOCR topic here: How to use the IntelligentOCR Package

@krishnareddy

Read PDF to text and do String manipulations.

try to split the string by new line and then tab or space to get the values.