Skip to content

Instantly share code, notes, and snippets.

@lukeholder

lukeholder/file.csv

Created April 9, 2014 08:07
Show Gist options
  • Save lukeholder/10239361 to your computer and use it in GitHub Desktop.
Save lukeholder/10239361 to your computer and use it in GitHub Desktop.
Download ZIP
non standard csv file with comment lines
Raw
file.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 17 in line 1.
; This is a comment
DC,4470-001,,01-405,G,3,16/03/2014,16/03/2014,Payroll Costing 16/03/14,0,,468.02,,,101001,,
DC,4470-001,,01-405,G,3,16/03/2014,16/03/2014,Leave Accrual,0.57,,33.34,,,101001,,
; Another comment
DC,4470-001,,01-410,G,3,16/03/2014,16/03/2014,Payroll Costing 16/03/14,0,,4212.18,,,101001,,
DC,4470-001,,01-410,G,3,16/03/2014,16/03/2014,Leave Accrual,5.57,,325.66,,,101001,,
; Another comment
GL,16/03/2014,16/03/2014,Generated recovery,5039.20,110-60002-51-8002.001,,101001,,,,,,,,,
GL,16/03/2014,16/03/2014,Generated recovery,-5039.20,110-60002-51-6535.001,,101001,,,,,,,,,
GL,16/03/2014,16/03/2014,Payroll Costing 16/03/14,-2883.61,130-00000-00-3210.000,,101001,,,,,,,,,
GL,16/03/2014,16/03/2014,Payroll Costing 16/03/14,-359.00,130-00000-00-3210.001,,101001,,,,,,,,,
GL,16/03/2014,16/03/2014,Payroll Costing 16/03/14,-1054.00,130-00000-00-3210.004,,101001,,,,,,,,,
GL,16/03/2014,16/03/2014,Payroll Costing 16/03/14,-141.76,130-00000-00-3210.005,,101001,,,,,,,,,
GL,16/03/2014,16/03/2014,Payroll Costing 16/03/14,-364.23,130-00000-00-3210.013,,101001,,,,,,,,,
GL,16/03/2014,16/03/2014,Payroll Costing 16/03/14,-236.60,130-00000-00-3210.015,,101001,,,,,,,,,
;
;
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment