Prev: find the upper edge of an image
Next: plotting loglog plot with Zero-Order-Hold
From: harry peter86 on 8 Jul 2010 01:02
"Sven Schoeberichts" <sven(a)wires.nl> wrote in message <h75st6$chf$1(a)fred.mathworks.com>...
> Hey all,
>
> I have a .csv file containing measurement data which is formatted like this:
>
> 0,000000,0,003865,1,006453,0,000324
> 0,000000,0,003865,1,006453,0,000324
> 0,000000,0,003865,1,006453,0,000324
> 0,000000,0,003865,1,006453,0,000324
> for example
> so there is a comma as a decimal sign and as a seperator sign. I need the outcome to be like:
>
> 0.000000
> 0.000000
> 0.000000
> 0.000000
> in the first column
>
> 0.003865
> 0.003865
> 0.003865
> 0.003865
> in the second column
> etc.
>
> I tried csvread, which creates columns with the data between each comma, and thus removing all leading zero's.
>
> I tried several ways to get them back together, but non succesful. For instance str2num, to add the missing 0's and then merging the 1 and 2nd column, 3rd and 4th, and so on.
>
> or is there a way to change every first comma into a period before reading it from the csv file?
>
> All help would be great.
>
> Thanks!
> Sven

great&#65281; Anyone used spire.xls ? I feel it other easy way to read and write excel. maybe best excel component to .net. too powerful !!
http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html
 | 
Pages: 1
Prev: find the upper edge of an image
Next: plotting loglog plot with Zero-Order-Hold