Answered
textscan does not read all rows
If you pass in 'ReturnOnError',false with the textscan call, there will be an error message where the format cannot read your fi...

bijna 5 jaar ago | 0

Answered
readtable skipping some rows
detectImportOptions detecting Space as the delimiter, (correctly I think) and is looking at the "N/A" and "NE 45" and treating t...

bijna 5 jaar ago | 0

Answered
Read text file with multiple rows of fields
The current best way I know how to do this is with TEXTSCAN. fmt = "%s%s%s%s%*[^\r\n]%*[\r\n]%s%s%s%s" fid = fopen('sampleFile...

ongeveer 5 jaar ago | 1

| accepted

Answered
Problems with readtable within parfor on R2018b for Win 64
Try using READTABLE with the 'UseExcel',false parameter. (This might also be 'Basic',true in older releases.)

ongeveer 5 jaar ago | 0

Answered
First colum of CSV-imported table has "x___" added to its name
The file probably has a Byte Order Mark in the beginning. If you read the raw bytes using fopen/fread you can see the mark at ...

ongeveer 5 jaar ago | 2

Answered
How can I increase the speed of this loop?
It's hard to say without looking at the contents of the file's you're reading. You're overriding n in the for loop with n as th...

ongeveer 5 jaar ago | 0

| accepted

Answered
textscan with formatted input data
This should be able to read this without much issue. opts = detectImportOptions(filename) T = readtable(filename,opts)

ongeveer 5 jaar ago | 0

Answered
How to read specific numbers (colums) of a csv file
I'd do this: opts = detectImportOptions(filename); opts.SelectedVariableNames = opts.VariableNames([3 4]); T = readtable(file...

ongeveer 5 jaar ago | 0

Answered
Read a very large .csv file, split into parts and save each part into a smaller .csv file
If your plan is to write all the small CSV files out, and do nothing with them in MATLAB, I'd say just use tabularTextDatastore,...

ongeveer 5 jaar ago | 1

| accepted

Answered
Read a specified list of images given the filename and the directory the files are in
Datastores are convenient for reading collections of files. imds = imageDatastore(directory) imshow(read(imds)) Each time you...

ongeveer 5 jaar ago | 0

Answered
Readtable for a huge (no good schema) CSV file!
opts = detectImportOptions(FileName,'Delimiter',';','NumHeaderLines',18) T = readtable(FileName,opts)

ongeveer 5 jaar ago | 0

Answered
readtable not understood behaviour
A simpler way to do this would be: lines = splitlines(fileread(filename))

ongeveer 5 jaar ago | 0

Answered
Readtable from i-th row to last row
Try this opts = detectImportOptions(filename,'NumHeaderLines',6) T = readtable(filename,opts)

ongeveer 5 jaar ago | 3

| accepted

Answered
Readtable() confused by quotation marks? Matlab 2019a
opts = detectImportOptions('myfile.txt','FileType','text','Delimiter','|') T = readtable('myfile.txt',opts)

ongeveer 5 jaar ago | 0

| accepted

Answered
How to read in a non-standard formated CSV file containing times and measurments and change the output format?
You could do this with textscan fid = fopen(file); vars = textscan(fid,'TIM%f%fABC%fDEF%fGHI%f','Delimiter',{','},'Whitespace'...

meer dan 5 jaar ago | 0

Answered
readData() function error message when using mapreduce
ds.TextscanFormats{15} = '%q' That will at least get you past the one line that's causing the problem here. For a more robust a...

meer dan 5 jaar ago | 0

| accepted

Answered
Why writetable() adds ' 'true ' table element as ''table?
I think this is a case where using strings would make things more clear. In MATLAB, if I create a char vector and put a single-...

meer dan 5 jaar ago | 0

Answered
Set union of Datastores with TransformedDatastores
Horizontal (i.e. associated reads) ----------- cds = combine(imds,otherds); Vertical (i.e. joining two sets of files into o...

meer dan 5 jaar ago | 1

| accepted

Answered
MATLAB 2018a readtable VariableNamesLine bug
What is the result if you pass ReadVariableNames into the function? T = readtable(fullFileName, opts, 'ReadVariableNames', true...

meer dan 5 jaar ago | 1

| accepted

Answered
Matlab Compiler not updating text file
There may be another text file with the same name on your path. Try, which -all <filename>.

meer dan 5 jaar ago | 0

Answered
problem reading with format
The leading spaces are not being counted toward the width of the fields as you're expecting. %n.pf - will read at most n charac...

meer dan 5 jaar ago | 0

Answered
Loading/Reading .log File
Try this: data = readtable('omar_timing_test_MG125_Block_1.log','FileType','text') Jeremy

meer dan 5 jaar ago | 2

Answered
Windows .NET Framework Update Breaks READTABLE()
Try, readtable(filename,'Basic',true) % or UseExcel false in a more recent release.

meer dan 5 jaar ago | 0

Answered
WRITETABLE to spreadhseet mysterious failure
"=$0.00" This is probably the culprit. The writetable function has two modes: 'UseExcel' = true/false. If you're using Excel®,...

meer dan 5 jaar ago | 1

Answered
Transpose/combine several variables using csvwrite or writematrix
The function writematrix is available in R2019a.

meer dan 5 jaar ago | 0

Answered
import large csv file
The issue with 22 digits of precision in DECIMAL is that MATLAB's default number type is DOUBLE which really can only handle aro...

meer dan 5 jaar ago | 0

Answered
Effective way to extract rows (range) from a text file
Readling line by line is quite ineffecient. Try this: C = textscan(fid,'%f','delimiter','\n', 'headerlines',182);

meer dan 5 jaar ago | 0

Answered
How to convert xlswrite to writematrix?
XLSWRITE can write either a matrix (e.g. [ 1 2 4;5 7 8] or a cell {'a' 'b';'c' 'd'}) If your input is a cell, use WRITECELL. ...

meer dan 5 jaar ago | 0

Answered
Importing a Large CSV in chunks and getting Data Range Invalid
I'd reccomend using tabularTextDatastore for this case. It will try to automatically detect formats and handle the reading of se...

meer dan 5 jaar ago | 0

Answered
Extracting Unknown Amount of Columns from Excel Data
I recommend using READMATRIX if you have access to R2019a, or READTABLE for earlier releases. A = readmatrix(filename) Once yo...

meer dan 5 jaar ago | 0