TableTool
TableTool copied to clipboard
Detect separator when there are header rows
I work with a lot of ALE files (Avid Log Exchange). This format has a few header rows of plain text followed by tab-separated data. Table Tool always defaults to a comma separator, but I would love to automatically detect the tab. If I delete the header rows, then it correctly detects the tab separator. Sample file attached.
This heuristic might be difficult to implement, so I propose an easier workaround: A preference window where the user can set the default separator when guessing fails. I would guess most users probably work with the same kind of files often.
Thank you for sharing. Heuristics needs lots of good examples to work well. Can anyone else please share data files and where you got them from?