Answered
readtable does not allow 'Format' option
Hi Xiaoyu, If you're using R2016b or later, you can specify details like this with spreadsheet import options. opts = de...

2 years ago | 0

Answered
Error Message dataread and textread
Hi George TEXTREAD is trying to import numeric data but encountering text fields which cannot be converted. Basically, your f...

2 years ago | 0

Answered
Textscan and csv fitness data problem
Hi Using textscan is great if you have files with varying formats or if you need certain special behaviors. I found this on...

2 years ago | 0

Answered
Process .csv file, combine first two rows into 1 (text rows) to make them the variables
You could try using <https://www.mathworks.com/help/matlab/ref/detectimportoptions.html detectImportOptions> (R2016b or later) a...

2 years ago | 1

Answered
Problems With readtable. Convert string data in datetime with milissecond precision.
Your time seems to have a decimal separator of '.' it's the semicolon that's the issue. t = readtable('Test2.csv','Format',...

2 years ago | 0

Answered
Fast move in datastore (TabularTextDatastore)
Hi Adam, Unfortunately, there's not a way to do this. (And I don't mean with datastore--text files are linear things... to fi...

2 years ago | 2

| accepted

Answered
Subscript indices must either be real positive integers or logicals
Very common error. =) MATLAB arrays start at index = 1. You should see the same error from x(0,:) = 1. In this case, I don't ...

2 years ago | 0

Answered
How to import multiple csv files into one and read it from certain folder?
You can use tabularTextDatatstore to collect the CSV files and read them into one table >> ds = tabularTextDatastore(filepa...

2 years ago | 1

| accepted

Answered
How do I read this csv file in and convert the dates?
Hi, I have two things. The first is that readtable should recognize the format, and return datetimes (assuming you are in a...

2 years ago | 0

| accepted

Answered
Long time to load 40 gig file
"cell array tables" A good bet is that the cell arrays are the issue. Each cell of the array takes a 114 bytes of overhead. W...

2 years ago | 0

Answered
How to avoid variable name warnings when using filenames as variable names
The warning you're seeing comes from READTABLE; it's probably not related to the names of your files (unless those are being sto...

2 years ago | 4

| accepted

Answered
How can I read data from a datastore without knowing the exact data type?
Hi Peixin, I assume you don't know all the possible strings that can appear in this column. The only way I think you can proc...

2 years ago | 1

| accepted

Answered
string inside a table
Try: >> T = readtable(filename,'TreatAsEmpty',{'-'}) Jeremy

2 years ago | 0

Answered
Why does textscan read only 95% of my data file?
textscan can read time-of-day as datetime, having the format d = textscan(fid,'%D%D%f','Delimiter',' ','ReturnOnError',...

2 years ago | 0

Answered
How to turn .txt file into a useful table.
Hi, This is actually pretty simple: >> opts = detectImportOptions('abc.txt','Delimiter','.') >> opts.VariableNames= {...

2 years ago | 0

Answered
Read Text File and Store in Matrices
If you're using textscan, you might try the parameter "MultipleDelimsAsOne',true with 'Delimiter',' \t' The f...

2 years ago | 0

Answered
Fastest Way of Opening and Reading .csv Files (Currently using xlsread)
Since you have multiple files, you may want to consider using <https://www.mathworks.com/help/matlab/datastore.html datastore>. ...

2 years ago | 1

Answered
Textscan won't read the dates with spaces
Hi Per, The issue is that textscan's delimiter is space by default. Parsing happens first, then datatype conversion. In this...

2 years ago | 1

| accepted

Answered
Import data 800*7 textfile into cell array using textscan
You might also want to consider READTABLE. Each "column" of the file will be imported as a table variable in one array with a co...

2 years ago | 0

Answered
how to use readtable with excel spreadsheets, skip extra header lines, and read to "end"?
Hi Ian, Without the actual file you're trying to read it's hard to say for sure, but I think I can help. Header lines are assum...

2 years ago | 1

Answered
Need to know how to readtable() when file has row 1 variable names and row 2 units and the other rows data
Hi Doug, The good news is that readtable using import options was built for this. I think there might be some confusion on...

2 years ago | 1

Submitted


For-Each
Tools for simplifying for-loops. Customizable loop iteration.

2 years ago | 3 downloads |

Thumbnail

Answered
Error in using datastore function to read big data
Hi Eric, I'm guessing datastore is running into an issue parsing the file. This often happens when there is a non-number ent...

2 years ago | 1

Answered
Textscan with very large .dat files, Matlab keeps crashing
Hi, If you can access R2014b or later, I'd recommend using DATASTORE to manage your import. It automatically breaks up files i...

2 years ago | 0

Answered
TEXTSCAN is my personal nemesis: Quotes strings with commas
If you have access to R2016b, try using detectImportOptions with readtable. opts = detectImportOptions(yourfile); T...

2 years ago | 1

Answered
.csv Date and Time assigned Data Import
Hi George, If you're using R2016b you can import this directly, but it will take a little bit of configuration The following...

3 years ago | 1

| accepted

Answered
Why does dlmread fail to import my csv files using my matlab 2016b installation when the same code works properly in my 2016a installation?
This sounds like an installation issue. The missing function should be installed with MATLAB. You may want to reinstall MATLAB, ...

3 years ago | 0

| accepted

Answered
Why does my bash script work in the terminal but not when executed in Matlab?
I'd check the environment variables in MATLAB versus your console. MATLAB makes changes and might have altered something you sc...

3 years ago | 0

Answered
do timer callbacks all execute in the same thread
Hi Jim, The short answer is: Two timer callbacks cannot execute simultaneously. Jeremy

3 years ago | 1

Answered
I want to read this text file from Matlab directly and want to import data of all columns into work space in an array.
I suggest the 'CollectOutput' parameter fid = fopen('1.txt'); a = textscan(fid, '%s%s%s%s%s%s%s', 'Delimiter', '', 'Head...

3 years ago | 0

Load more