Hello Experts,
I have a chunk of data in PDF/text format and would want to output it as columns and rows in an excel.
Input: Please find the attached txt/pdf file
Expected Output:
| rule name | Left Criteria | Column | Op | Value | Logical | Right Criteria | Column | Op | Value | Logical | Left Match Group Tolerance | Right Match Group Tolerance | Left Item | Additional Info. (L) | Op | Left Item | Additional Info. (L) | Tolerance | Exception Status | Combo Rule |
| Desc3=2002 Eff Dt=1 | .=1 | Book Flag | = | 1 | AND | >1 | Bank Flag | = | 2 | AND | | effectiveDate | Effective Date | YYYYMMDD | = | Effective Date | YYYYMMDD | 1 Days | | No |
| Desc3=2002 Eff Dt=1 | | BICode 1 | = | 206 | | | Reference 3 | = | 2002 | | | | | | | | | | | |
| AI 206 | .=1 | Flag | = | 1 | AND | .=1 | Flag | = | 2 | AND | | effectiveDate | Effective Date | YYYYMMDD | = | Effective Date | YYYYMMDD | 1 Days | | No |
| AI 206 | | AICode | = | 206 | | | Reference 3 | = | 2002 | | | | | | | | | | | |
