demmings / gsSQL / 19901275578

95%

push

github

Imported CSV with Line Feed char

I had an issue where an imported bank transaction CSV file contained a line feed character in the description field.  When performing a select with calculated fields, the program aborted - EVEN though the field with the line feed character was not in the calculated field itself.  It has to do with how I process calculated fields.  A generated code block is passed to javascript to calculate the value and all data from the current record is included.  The javascript processor would fail.  I have decided to replace any tab, line feed and carriage return with a space - but only for data passed in to perform a calculation - e.g. in my case it was the YEAR() function on the transaction date.

1594 of 1685 branches covered (94.6%)

Branch coverage included in aggregate %.

9 of 9 new or added lines in 2 files covered. (100.0%)

13199 of 13805 relevant lines covered (95.61%)

283.47 hits per line