Below is an example of how I can use Matlab to read the type of file I
gave an example of earlier. Sorry if this doesn't display very well.
If there are some tags that I could put around my text to make it appear
nice and neat on this platform then let me know.
pathToFile = 'testData.csv';
fprintf('Opening file: "%s"\n', pathToFile);
raw = importdata(pathToFile, ',');
if isequal(raw, 0)
fprintf('Could not import raw data.\n\n');
else
fprintf('Now parsing data...\n');
dimensionsText = size(raw.textdata);
dimensionsData = size(raw.data);
if dimensionsText(1) == dimensionsData(1)
% if raw.textdata is the same length as data, then the
% file was corrupted and doesn't have column titles or
% decimal places.
warning(['Selected data log was recovered from a ' ...
'corrupted log. Be wary of unexpected results.'])
logDate = raw.textdata(:, 1);
timeOfDay = raw.textdata(:, 2);
value1 = raw.data(:, 1) ./ 1000;
value2 = raw.data(:, 2) ./ 1000;
else
logDate = raw.textdata(2:end, 1);
timeOfDay = raw.textdata(2:end, 2);
value1 = raw.data(:, 1);
value2 = raw.data(:, 2);
end
end
On Tue, 13 Nov 2018 at 13:10, PhilipNienhuis <address@hidden
<mailto:address@hidden>> wrote:
Owen Cail wrote
> I'll start by saying I'm in the process of moving from Matlab to
Octave.
>
> I am trying to import data from a text file, such as the example
below:
>
> date, time, value1, value2
> 2018-11-12, 15:44:21.123, 13, 205
> 2018-11-12, 15:44:22.123, 17, 201
>
> The result of is a struct with two fields: one called data, and
one called
> textdata:
>
> data =
>
> 13 205
> 17 201
>
> textdata =
> {
> [1,1] = date, time, value1, value2
> [2,1] = 2018-11-12
> [3,1] = 15:44:21.123
> [4,1] = 2018-11-12
> [5,1] = 15:44:22.123
> }
>
> The data part is exactly what I would expect, but the textdata
result is
> in
> a form that is not very useful. In Matlab, I was able to have a
column
> full of dates and a column full of times. The header being all in one
> cell
> is weird but is fine. My issue is that both columns of data are
combined
> in to one column.
>
> Is this intended behavior and I should just deal with it? Or can
I submit
> a bug report with these details?
How would you read this with matlab? Any code example?
P