How to extract column and data found in PDF file then create an EXCEL for the records

Help Forum
1

Hello,

I hope you can help me how to to go about my problem. I have this data in PDF form. I need to create an excel file that will house each record using the first string before colon as column name then the next part as the record it self. The record will break or new line process is whenever I encounter ACCOUNT/NOTE:. Below data should be look like this in Excel

918         FIRST TIME BANK                 LOAN ACCOUNTING      CREDIT BUREAU SUMMARY     R-7209-001-001 02-28-22   PAGE      1

ACCOUNT/NOTE:  00099999999/00001  DAYS PAST DUE: 00000                                       CREDIT BUREAUS:

BASE,BORROWER: LAST NAME: Ico                       FIRST NAME: Sherwin            MIDDLE NAME: C                     GEN:
SSN: 555555555  BIRTH DATE: 11081965  PHONE: 6777777777  ECOA: 1  CONSUMER IND:     COUNTRY CODE:
ADDRESS LINE 1: 139 PAKO MANILA          ADDRESS LINE 2:
CITY: DEDEDO                STATE: GU  ZIP: 911111      ADDRESS IND:    RESIDENCE CODE:

BASE,DETAIL:
PORT TYPE: I  ACCT TYPE: 00  DATE OPENED: 11092020  CREDIT LIMIT: 000000000  HIGH CREDIT AMT: 000014183
TERMS DURATION: 061  FREQUENCY: M  SCHED PMT: 000000254  ACTUAL PMT: 000000000  ACCT STATUS: 11
PMT RATING: PMT HISTORY: BBBBBBBBBBBBBBBBBBBBBBBB  SPEC COMMENTS: CONDITION CD:
CURRENT BAL: 000010797  AMT PAST DUE: 000000000  CHG OFF AMT: 000000000  INFO DATE: 02282022
DELQ DATE: 00000000  DATE CLOSED: 00000000  LAST PMT DATE: 00000000  INT TYPE IND: F

ACCOUNT/NOTE:  00002000143/00001  DAYS PAST DUE: 00000                                       CREDIT BUREAUS:

BASE,BORROWER: LAST NAME: ICO                     FIRST NAME: Sherwin              MIDDLE NAME: A                     GEN:
SSN: 555555555  BIRTH DATE: 00000000  PHONE: 0002222222  ECOA: 2  CONSUMER IND:     COUNTRY CODE:
ADDRESS LINE 1: 187 MOBSTA                   ADDRESS LINE 2:
CITY: DEADPOOL                STATE: GU  ZIP: 99999      ADDRESS IND:    RESIDENCE CODE:

![image|690x59](upload://rZFlrvfee6Vx6AVt1BFFcdwpdRu.png)


												
![UIPath question Exel|690x240](upload://eB5BdowZDAte3qxFawx2nu1GzGL.png)
2

Hello! Welcome to community,

Follow the steps below:

  1. Install the UiPath.PDF.Activities from manage packages
  2. Take one read pdf activity → Provide the file path->Output->strPDF
  3. Take one generate DataTable activity provide the strPDF and output As DataTable
  4. Open the Generate DataTable wizard. Modify the separators Try with different methods you’ll get the desired output.

If dataTable present in the PDF you can directly get the datatable from the pdf.

Regards,
NaNi

3

Hello Nani,

Thank you so much for the response. However, I could not make it in the wizard to create a table that will pick the column name then write the data under it. Could you describe it further? Thank you!