|
|
|
|
|
csv1.png (47,117 bytes) |
|
|
csv2.png (45,432 bytes) |
|
|
I am surprised if Excel cannot use tab as separator. I never have problem with OpenOffice to open this files, see attached screenshot. I prefer to use tab over coma for the reason explained on the wikipedia page you link. Coma is used as a decimal separator on many countries, so you need to double quote any numeric field to avoid problems. But we use double quote for arcsecond unit that now need to be doubled in the file. Using tab you not have this problem and produce a file easy to read in any text editor. |
|
|
Yes, Excel can use tab as separator, but its behaviour is: - If the extension is .csv, it opens the file directly assuming the separator is a coma, and you get a mess of a file. - If the extension is .txt it opens a dialog to let you select the separator used, as OpenOffice does, then you choose Tab as separator and it works. No big issue, I can save the file with .txt extension and it works on both. Second issue is the column names. In the current output they are mixed with the column values, which makes the lines unnecessary long, bad for printing. I would prefer something cleaner, as in the example I sent. |
|
|
OK, I look how to add option for that at the same time I work on 0000213 |
|
|
Revision 1573 use comma separator if extention is .csv, tab for other extention (.tsv suggested). When using .csv any comma in data is replaced by a dot. As the file can contain data from many catalog source with different column content it is not possible to normalize the column except for RA,DEC,Type,Name,Magnitude. Even for magnitude it is not possible to remove the name from the column as it can indicate the color, depending on the source catalog. http://svn.origo.ethz.ch/viewvc/skychart?view=rev&revision=1573 |
- Anonymous
