I am using xlsread to grab some number and text data in Excel. The text data contains values in the date time format as follows (I can't change the source code producing this format):
TimeStamp
02/19/2010 05:13:05.068 AM
02/19/2010 05:13:10.067 AM
02/19/2010 05:13:24.067 AM
Using:
[num text raw] = xlsread(filename,'worksheet');
The ".068", ".067", and ".067" do not pass through the function and I end up with:
02/19/2010 05:13:05 AM
02/19/2010 05:13:10 AM
02/19/2010 05:13:24 AM
Also occurs within the "raw" matrix. I can change it manually if I open Excel and serialize the values, but would like this to be automated.
thanks for any help. Anthony
|
|
0
|
|
|
|
Reply
|
 Anthony
|
5/10/2010 7:16:23 PM |
|
"Anthony Brinkley" <Anthony.Brinkley@dynetics.com> wrote in message <hs9m26$ojr$1@fred.mathworks.com>...
> I am using xlsread to grab some number and text data in Excel. The text data contains values in the date time format as follows (I can't change the source code producing this format):
>
> TimeStamp
> 02/19/2010 05:13:05.068 AM
> 02/19/2010 05:13:10.067 AM
> 02/19/2010 05:13:24.067 AM
>
> Using:
> [num text raw] = xlsread(filename,'worksheet');
>
> The ".068", ".067", and ".067" do not pass through the function and I end up with:
> 02/19/2010 05:13:05 AM
> 02/19/2010 05:13:10 AM
> 02/19/2010 05:13:24 AM
>
> Also occurs within the "raw" matrix. I can change it manually if I open Excel and serialize the values, but would like this to be automated.
>
> thanks for any help. Anthony
I tried your example , and it worked perfectly on my computer, the '0.68', '0.67', and '0.67' pass through.
What version of Excel and MATLAB are you using.
|
|
|
0
|
|
|
|
Reply
|
ade77
|
5/10/2010 8:21:09 PM
|
|
"ade77 " <ade100a@gmail.com> wrote in message <hs9prl$774$1@fred.mathworks.com>...
> "Anthony Brinkley" <Anthony.Brinkley@dynetics.com> wrote in message <hs9m26$ojr$1@fred.mathworks.com>...
> > I am using xlsread to grab some number and text data in Excel. The text data contains values in the date time format as follows (I can't change the source code producing this format):
> >
> > TimeStamp
> > 02/19/2010 05:13:05.068 AM
> > 02/19/2010 05:13:10.067 AM
> > 02/19/2010 05:13:24.067 AM
> >
> > Using:
> > [num text raw] = xlsread(filename,'worksheet');
> >
> > The ".068", ".067", and ".067" do not pass through the function and I end up with:
> > 02/19/2010 05:13:05 AM
> > 02/19/2010 05:13:10 AM
> > 02/19/2010 05:13:24 AM
> >
> > Also occurs within the "raw" matrix. I can change it manually if I open Excel and serialize the values, but would like this to be automated.
> >
> > thanks for any help. Anthony
>
> I tried your example , and it worked perfectly on my computer, the '0.68', '0.67', and '0.67' pass through.
>
> What version of Excel and MATLAB are you using.
Excel 2007. Matlab 2009a. I'm on a 64-bit machine.
|
|
|
0
|
|
|
|
Reply
|
Anthony
|
5/11/2010 1:07:04 PM
|
|
|
2 Replies
307 Views
(page loaded in 0.041 seconds)
Similiar Articles: Copy-on-write for real/imaginary parts of complex data? - comp ...... creates a shared data copy of the input off ... would make the cut. Still, even for systems with plenty of physical memory, the time spent copying data ... pages - comp.text ... input & output in assembly - comp.lang.asm.x86... address dc.l FSizeOf_text ; size of raw data ... in it, and only a small fraction of them ... A Q A R T A Data AcQuisition And Real-Time Analysis ... improve strlen - comp.lang.asm.x86... rarely do, as a matter of fact, as only fraction of code is time ... CPU, shaving one or two clock cycles off the execution time of ... And "contemporary" doesn't even cut it. The ... [comp.publish.cdrom] CD-Recordable FAQ, Part 1/4 - comp.publish ...Archive-name: cdrom/cd-recordable/part1 Posting-Frequency: monthly Last-modified: 2008/10/09 Version: 2.71 Send corrections and updates to And... How best to detect duplicate values in a column? - comp.databases ...Perhaps at some later time when there are more than ... to 12 characters each, and only a very small fraction of ... Cut it off entirely? >of asking "agree/disagree that we ... Need a FORTRAN compiler for Win7 (or XP) - comp.lang.fortran ...If test data with a listing if the expected ... argument passing time is a significant fraction of the time ... Cut and paste the text into Notepad, save as whatever.for and ... Could anyone give me the spice-mode.el - comp.emacsHi, All I am new to *NIX and I am thinking of writing spice code under Emacs. However, I have no idea of Emacs Lisp. Hence, I could not write a packa... top 10 uses for random data compression?? anyone? - comp ...Imagine that you could compress any data by just few more bytes, every time. ... Yet Anne Truitt signed off on the 1995 L. A ... If the younger clues can cut finally, the ... Dos and don'ts in C++ unit testing? - comp.lang.c++.moderated ...Having said that, I've got to admit that a large fraction ... Then I might test the display of simple text elements ... but a test which runs for several years just won't cut ... How to get envelope from AM signal without phase shift - comp.dsp ...... is expected to only occur within a fraction (<1/10 ... the water 2) Record the echo reflected off ... where the triangle peak should be the Time Span of the windowed data plus ... Video series: Reading Excel data into MATLAB with a GUI | File ...... pretty easy to read in the data with XLSREAD: ... I know that I can do it by cut and paste the data in .mat file but it will be time ... using ANSYS and obtain my data in a text ... MATLAB Basics video: Row and Column indexing | File Exchange Pick ...... he is talking about shave small fractions of a second off ... and when it was fixed his run time was cut ... on the right tracks – I can xlsread the file, returning the text ... 7/13/2012 10:46:18 AM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
485 followers. 