Back to Simulations

Multi-Line Descriptions & Truncation

Bank descriptions that wrap to multiple lines (common in PDF-to-CSV conversions), descriptions truncated at 30 or 40 characters, and memo lines mixed in as separate rows.

Medium BANK
12
Total Rows
12
Valid (date+amount)
0
Invalid/Skipped
0
Warnings
A
Grade (100%)

Known Problems in This Document

  • Multi-line descriptions split across 2-3 CSV rows
  • Truncated at 30 chars: "ACME CORP PAYMENT FOR INV" (rest cut off)
  • Memo/detail lines appear as separate rows with no date/amount
  • Some descriptions are ALL CAPS, others mixed case
  • Reference numbers buried inside description text

Actual Parser Errors & Warnings

No errors or warnings

Side-by-Side: Original Document vs Parser Extraction

Original Document Content (multiline_truncated_bank.csv)
Parser Extraction Result
1 Date,Amount,Description,Reference,Balance
Skipped (header row)
2 03/01/2026,-1500.00,ACME CORP STANDARD PAYMENT,REF-001,20500.00
2026-03-01 -1500.00 ACME CORP STANDARD PAYMENT REF-001
3 03/02/2026,-2340.50,BOLT INDUSTRIES PAYMENT FOR IN,REF-002,18159.50
2026-03-02 -2340.50 BOLT INDUSTRIES PAYMENT FOR IN REF-002
4 03/03/2026,-875.00,"CROWN SUPPLY CO
2026-03-03 -875.00 CROWN SUPPLY CO INVOICE 4421 AND 4422 NET 30 TERMS REF-003
5 INVOICE 4421 AND 4422
2026-03-04 -3100.00 DELTA SERVICES LLC REF-004
6 NET 30 TERMS",REF-003,17284.50
Row not captured by parser
7 03/04/2026,-3100.00,DELTA SERVICES LLC,REF-004,14184.50
2026-03-05 5000.00 CUSTOMER DEPOSIT FRESHMART INC DEP-001
8 ,," MEMO: Annual maintenance contract renewal",,
2026-03-06 -780.00 EAGLE TRANSPORT FREIGHT CHARG... REF-005
9 03/05/2026,5000.00,CUSTOMER DEPOSIT FRESHMART INC,DEP-001,19184.50
2026-03-07 -450.00 FOX HARDWARE - SUPPLIES REF-006
10 03/06/2026,-780.00,EAGLE TRANSPORT FREIGHT CHARG...,REF-005,18404.50
2026-03-08 -1200.00 globe telecom monthly service REF-007
11 03/07/2026,-450.00,FOX HARDWARE - SUPPLIES,REF-006,17954.50
2026-03-09 -950.00 HARBOR SHIPPING REF:HS-88214 FREIGHT X-EMBEDDED
12 03/08/2026,-1200.00,globe telecom monthly service,REF-007,16754.50
2026-03-10 -1600.00 PAYMENT TO ACME CORP, ACCOUNT #12345, WIRE TRANSF… REF-008
13 03/09/2026,-950.00,HARBOR SHIPPING REF:HS-88214 FREIGHT,X-EMBEDDED,15804.50
2026-03-11 -200.00 447891 CHK-447891
14 03/10/2026,-1600.00,"PAYMENT TO ACME CORP,
2026-03-12 150.75 MISC-001
15 ACCOUNT #12345, WIRE TRANSFER
Row not captured by parser
16 BATCH REF: B-9921",REF-008,14204.50
Row not captured by parser
17 03/11/2026,-200.00,447891,CHK-447891,14004.50
Row not captured by parser
18 03/12/2026,150.75,,MISC-001,14155.25
Row not captured by parser
Previous Next