Tagged: column headers
- November 6, 2017 at 5:48 pm #22614
I am not exactly sure what the feature and purpose that you are requesting are. Can you please define your requested feature? Do you want EmEditor to select the correct CSV mode looking at the 4th row (ignoring 1st – 3rd)? Is this only for the “auto selection” of the CSV?
Thanks,November 8, 2017 at 3:10 am #22617
Dear Mr. Emura,
Thank you for your reply. The problem arises when there are too many comment lines that get in the way of viewing the tabular data. In particular, there are two problems:
1) Scrolling behaviour: scrolling fixes the first comment line(s), and not the actual table header. The optimal scrolling behaviour would be: normal scrolling at the top of the file, until the header line (first non-comment line) is the uppermost displayed line. When scrolling further down, this line is locked and stays at the top of the display (as in current CSV mode).
2) Visibility of comment lines: the comment lines are cut off at the edge of the first column (making the first column wide enough to fit the comments is not a viable solution, since they can have up to a few thousand characters). This problem is not as important as the first one, but seeing the complete line would be “nice to have”.
Auto-recognition is not so important in my case, since the files have a specific ending. For column selection, CSV merging etc. the comment lines could be completely ignored and just the tabular data used.
ThomasNovember 8, 2017 at 4:51 pm #22618
I think I understand your both feature requests, but I don’t want to make EmEditor too complicated.
As for 1), you can use the Filter feature to filter out the comment lines (for instance, filter with # with negative option).
Thanks,November 14, 2017 at 12:44 am #22620
Dear Mr. Emura,
Unfortunately the filter feature has a lower priority than the fixation of the header, i.e. the first (comment) line is fixed and the actual table header disappears when scrolling. Is there a possibility to invert that behaviour?
I understand your concern on making EmEditor complicated, one of the great things about EmEditor is the huge functionality in a user-friendly interface. However, I personally think that the option to ignore comment lines in CSV files is not a too complex feature, and hope that it may still be integrated in a future release.
You must be logged in to reply to this topic.