generating a CVS file for recording results instead of simple txt format

[J.Dred]

dear friends,

I want to save my chart results to a csv format ,to be able to open it in Excel file later on.

any suggestion for doing this? should i simply conver the text data to csv data?

additionally I have another problem here:

my results look like this

3,10,213,20,5,30

but though they should look like this

3.10,213.20,5.30

so excel will assign each value to a coloumn (with each comma ,next colomn is assigned)


pls see my vi
regards


Message Edited by J.Dred on 12-16-2007 02:59 PM

[altenbach]

Apparently your computer has a country setting that defines the comma as decimal seperator. It is not a good idea to use csv in this case!

You can unckeck "use localized decimal point" in the front panel options.

You can also force a decimal point instead of comma as decimal separator by adding %.;  to your format string (%.;%.03f,%.03f,%.03f,%.06f in your case).

Why do you use a seperate loop for the random numbers???

Message Edited by altenbach on 12-16-2007 01:08 PM

[J.Dred]

the point I use another loop is to simulate my actual code ( my inputs are arrays) , i know that I could use them in the second loop 😉

thank you very much , it works fine with (%.;) , now what do you advise me so I can open those results in Excel? (each value new row)

best regards

[J.Dred]

or you have a better idea for recording the results in Excel ? (1.000.000 values)

[tbob]

It's called CSV, for Comma Separated Variables.  CVS is a pharmacy.

[GerdW]

Hi J.,

only the newest version of Excel will take 1 million rows (IMHO), older versions are limited to 65535 rows!
What about Diadem (from NI)?

[ryan_d]

Hi all,

The "Write to Spreadsheet File" VI (Programming » File I/O) is an easy way to write data to a .CSV. However, GerdW is correct with the row limitation of Excel. If you're just doing post processing, I'd save the data into .tdms or another binary file type and do my data processing in LabVIEW.


Message Edited by ryan_d on 12-17-2007 03:24 PM