Allow sep=, in Database Viewer

We welcome any suggestions for new features or improvements in Altap Salamander. Please post one suggestion per report.
User avatar
mdruiter
Posts: 258
Joined: 22 Feb 2006, 15:33
Location: Amsterdam, The Netherlands
Contact:

Allow sep=, in Database Viewer

Post by mdruiter » 18 Dec 2014, 22:26

I use the Database Viewer all the time, mainly to view delimited text files. It works great most of the time. But sometimes, it uses the incorrect Separator :(. For instance because I have Tabulator as the default instead of Auto-Select, as that's by far the most common one in the files I use and the viewer guesses wrong every now and then. Of course I can solve that every time by choosing a specific separator, but it would be great if Salamander would 'guess right' more often. Wouldn't it be great if a file could specify its separator to know for sure?

Now Excel has a similar problem: if the file is called *.csv, it assumes as the value separator the List separator from the Regional Settings, which is the semicolon (;) over here in The Netherlands. Even though Comma-Separated Value files, due to their name, are widely expected to be separated by commas (,)...

Today I found out, that Excel can be forced into using a specific separator: just add a top line containing sep=,!
Wouldn't it be great if Salamander allowed this as well :idea: ? Just read, interpret and hide the sep=? line, then use the specified separator to interpret the rest of the file. Maybe optional using some option switch.

User avatar
Ether
Posts: 1459
Joined: 10 May 2007, 16:08
Location: Czech Republic
Contact:

Re: Allow sep=, in Database Viewer

Post by Ether » 20 Dec 2014, 22:11

Is this recognized by any other software than Excel?
Ελληνικά rulez.

Post Reply