Answered
Trouble loading in mixed data from txt file
You're adding 'CollectOutput' which is concatenating all the numeric columns into one. If you remove that, you should get the nu...

2 years ago | 1

| accepted

Answered
Yet another TEXTSCAN question...
If the numbers are always surrounded by double-quotes, try this, t = textscan(s,'"%f""%f""%f"','Delimiter',',') or, ...

2 years ago | 0

Answered
" Error using readtable (line 198) An internal error occurred ". How can I solve this issue?
I tried, T = readtable('Nuevo.xlsx') T = readtable('Nuevo.xlsx','Basic',true) And both worked for me. Sometimes the ...

2 years ago | 1

Answered
readtable function ignores certain options
READTABLE uses the variable names defined in the Options over the ones in the file. This is because you can re-use the options o...

2 years ago | 0

Answered
error using readtable with "opts" and "TreatAsEmpty" together
Hi, Only a subset of the parameters in READTABLE are allowed with the options. Part of the reason is that, in the import opti...

2 years ago | 0

| accepted

Answered
reading in text files
You should try |tabularTextDatastore| assuming everything has the same format. ds = tabularTextDatastore(pathToFiles) ds...

2 years ago | 1

Answered
Convert timestamps in CSV file to seconds using readtable and table2timetable
This will work as long as the times are on the same day (as in the file). T = readtable(file,'Format','%{dd-MMM-uuuu HH:m...

2 years ago | 0

| accepted

Answered
readtable can't get variable names from csv if different number of columns
Try giving a hint. opts = detectImportOptions(filename,'NumHeaderLines',0); T = readtable(filename,opts)

2 years ago | 2

| accepted

Answered
Error when synchronizing two time series
Hi, I think this is a simple fix, this code may not do what you think it's doing: t1 = SP(:,1); % is a table I don't thi...

2 years ago | 0

Answered
large csv import and split
With a file that's 25GB, you're going to need to break the data up. I recommend using ds = tabularTextDatastore(filename...

2 years ago | 0

Answered
Hello .. how to read a text file which is a matrix of [1000x512] order of complex numbers. could anyone please help me over this
Hi Darapu, This worked for me. T = readtable('Extracted_Dry_Tar_Road_prediction_file.txt','Whitespace',' ()'); T.Va...

2 years ago | 1

| accepted

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 | 5

| 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= {...

3 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...

3 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>. ...

3 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...

3 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...

3 years ago | 0

Load more