You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I was working with excel files that were sent to me, and noticed in some cases that tabby-many tsv files produced by xlsx2tabby had some empty lines (i.e. delimiters only). In one case it was just two extra lines, but in another a file had 1 048 576 lines while it should have had 4. This later caused load_tabby to hang.
I can share the file privately, but in general I suppose this can happen when formatting has been applied in a particular way in excel / libre office. And FTR, such a file can be sanitized with sed -i '/^\s*$/d' <filename>, so it's not that big of a deal.
Should xlsx2tabby strip such empty lines?
The text was updated successfully, but these errors were encountered:
mslw
linked a pull request
Nov 21, 2023
that will
close
this issue
I was working with excel files that were sent to me, and noticed in some cases that tabby-many tsv files produced by
xlsx2tabby
had some empty lines (i.e. delimiters only). In one case it was just two extra lines, but in another a file had 1 048 576 lines while it should have had 4. This later causedload_tabby
to hang.I can share the file privately, but in general I suppose this can happen when formatting has been applied in a particular way in excel / libre office. And FTR, such a file can be sanitized with
sed -i '/^\s*$/d' <filename>
, so it's not that big of a deal.Should
xlsx2tabby
strip such empty lines?The text was updated successfully, but these errors were encountered: