Please use our GitHub Issues page for all new support inquiries. If you need to contact us directly, please e-mail [email protected]

When I export data as a CSV file, all the numbers (codes) entered have a minus sign before them even though they weren't entered that way. Does anyone know why this is and how to fix it? Similarly, entering -999 as a code in Datavyu shows up as /-999 in the CSV file. Is there a way to get rid of the / symbol? I want the CSV file to have the numbers the same way it was entered while coding.

Also, is there any way to make it so that all the columns in a spreadsheet are adjacent to each other in the CSV file, instead of one below the other? Would I have to create a script to do this?

asked 19 Aug '14, 13:07

NR90's gravatar image

NR90
1333
accept rate: 0%


What version of Datavyu are you using? I tried to replicate this issue with the newest stable version (1.2) and the column data was adjacent. Could you please send me the datavyu file and the accompanying CSV file so I can see the problem on my end?

My email is [email protected]nyu.edu.

permanent link

answered 21 Aug '14, 19:35

david's gravatar image

david ♦
143235
accept rate: 4%

Thanks for sending your files. I took a look at your csv file and it definitely doesn't look like it should. I tried exporting the file on my end and it worked. I did some digging and I think I figured out the issue. When you want to export a file as a csv you need to click File->Export File-> then check that it's format is being saved as a csv and name the file appropriately. I think you had been clicking File->Save As-> and then changing the format to csv. This latter method of creating a csv file is what produces the wonky output. So in the future, when creating a csv file use the Export File function.

permanent link

answered 28 Aug '14, 11:03

david's gravatar image

david ♦
143235
accept rate: 4%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×6
×4

question asked: 19 Aug '14, 13:07

question was seen: 4,378 times

last updated: 28 Aug '14, 11:03

powered by OSQA