jcomma: flexible conversion and sanitization of CSV and TSV files

jcomma can be used:

• manually, from here or another installation
• programatically via its API
• as a library integrated into another product
• in a Linux or Windows shell command or pipe

Help | MIT License | On GitHub

This page lets you prepare a recipe which tells jcomma how to interpret CSV files laid out in a particular way, e.g. by a bank's statement download. You can then apply the same recipe repeatedly to the same kinds of file. (No data is retained on the server; no cookies are used).

• ↕ ❌
  If column... field...

  empty (no text at all) whitespace only or empty matches regular expression does not match regular expression equal to not equal to greater or equal to: less or equal to: before (date): after (date): equal to column in previous row: not equal to column in previous row:
• ↕ ❌
  Column

  empty (no text at all) whitespace only or empty matches regular expression does not match regular expression equal to not equal to greater or equal to: less or equal to: before (date): after (date):
• ↕ ❌
  Fields of output record:
  

  + another field
  Don't output record in any of theses cases:
  

  + another "don't output record" condition
• ↕ ❌
  if field empty (no text at all) whitespace only or empty matches regular expression does not match regular expression equal to not equal to greater or equal to less or equal to before (date): after (date): equal to column in previous row: not equal to column in previous row:
• ↕ ❌
  Field name: D: Date T: Amount M: Memo C: Cleared status: blank (not cleared), "*" or "c" (cleared) and "X" or "R" (reconciled). N: Cheque number or "Deposit", "Transfer", "Print", "ATM", "EFT". P: Payee, or description for deposits, transfers, etc. A: Address of Payee. Up to 5 address lines allowed. L: Category or Transfer and (optionally) Class. F: Flag as reimbursable business expense. S: Split category (same as L) E: Split memo $: Amount for split item %: Percent. Used if splits are done by percentage N: Investment Action (Buy, Sell, etc.) Y: Security name I: Price (investment) Q: Quantity of shares O: Commission cost $: Amount transferred don't include in output
  Field concatenated from:
  

  + another column or text
  Field options: (applied in order)
  

  + another option
• ↕ ❌
  choose… ignore currency symbols as follows treat '(1.23)' or '1.23-' as negative: '-1.23' trim surrounding white space replace all occurences of string replace using regular expression: output as number output as sum of numbers output as ISO date output as custom date skip next option if: skip next option unless: omit field if: carry over from previous record instead if: stop with error if value: value earlier field column (letter/header) is empty (no text at all) is whitespace only or empty matches regular expression does not match regular expression equal to not equal to greater or equal to less or equal to is before (date): is after (date): equal to column in previous row: not equal to column in previous row: stop on conversion error negate after conversion US dates: e.g. treat 3/4/2016 as March 4 output time as well as date
• ↕ ❌
  choose… column (letter or header): column in previous row: earlier field (in this record): field in previous record: verbatim text: row offset: trim prefix minus append comma append space