Jeremy Hughes

Last seen: Today

MathWorks

117 total contributions since 2015

Software Developer, Musician and Science Fiction Writer.

Jeremy Hughes's Badges

Answered
table calculation for CSV file
I tried readtable('CSVCWtable3') but MATLAB said Unable to find or open 'CSVCWtable3'. Check the path and filename or file permi...

2 days ago | 0

Answered
How can I import multiple .CSV files in MATLAB and SISTEMATICALLY process the data of each file?
You could also look at tabularTextDatastore with transform, and writeall functions. This is the basic way that's done, but you m...

2 days ago | 0

Answered
How to skip file in imageDatastore.ReadFcn?
The only way to do this is to remove the files from the Files list on the ImageDatastore, or make a copy of this dataset which c...

2 days ago | 1

| accepted

Answered
how to fix "unrecognized table variable name" error?
'ReadVariableNames',false This tells readtable not to read variable names from the file. So all the variable names will be "Va...

6 days ago | 0

Answered
problem with the function "fread"
The error indicates that fopen returned an invalid file ID. Try this: [fid,msg] = fopen(filename) if fid < 0 error(msg) ...

12 days ago | 0

Answered
Read fixed number of numbers from text file
I assume the dots are meant as ellipses and not literally dots in the file. If so, you can use textscan pretty effectively here....

22 days ago | 1

| accepted

Answered
Import multiple .csv files with different of variables and rows
More recent versions of MATLAB generate code with the Import Tool which used the Import Options and readtable. The code is simpl...

2 months ago | 0

Answered
Csv file: reading values with comma
I think you need to set the decimal separator and thousands separator. Also, duration may be the better type for two of the vari...

4 months ago | 0

Answered
Problem to read csv file with a blank line
Hi, As others have pointed out, your CSV (Comma separated value) file is actually semicolon separated. If readtable is using c...

4 months ago | 0

Answered
How to import data from attatched csv file?
In R2020a, T = readtable('data.csv','TrimNonNumeric',true,'NumHeaderLines',11); or in earlier releases, opts = detectImportO...

6 months ago | 1

Answered
How to import data from .txt file?
The textscan function expects a fileID, not a file name. you need to use fopen. [filename,pathname]=uigetfile({'*.fl.txt' 'Torq...

6 months ago | 0

Answered
readtable with multiple date formats
Without seeing the file, I can only guess, but I'd try the following first: T = readtable(filename,'DateLocale',locale,...) No...

6 months ago | 0

| accepted

Answered
How to use Excel application, how can i know all the functions and ways to use it?
Active X is a Microsoft feature, controling the application depends on the APIs the application exposes. For Excel, you should c...

6 months ago | 1

Answered
using spreadsheet column headers as variable
When you create import options from scratch, you need to specify all the information, including where the variablenames and data...

8 months ago | 0

Answered
Error using readmatrix - Unable to determine range. Range must be a named range in the sheet or a single cell within 'XFD1048576'.
'Range' also accepts numeric inputs [r1 c1 r2 c2], the drawback being you need to specify the columns. You can specify only the...

9 months ago | 1

| accepted

Answered
Using writetable to create a text file
WriteMode is available in R2020a. What version are you using?

9 months ago | 0

Answered
How to change the date format of ,txt file?
https://www.mathworks.com/matlabcentral/answers/516121-how-do-i-specify-a-datetime-format-when-reading-a-csv-excel-file

10 months ago | 0

| accepted

Answered
Errors using xlsread to import data from Excel
Sometimes the Excel instalation can break xlsread, there shouldn't be a reason MATLAB install changed anything for you. It might...

10 months ago | 1

| accepted

Answered
how to check whether a sheet exists or not, while using readtable function
I don't know if it's any better, but there is https://www.mathworks.com/help/matlab/ref/sheetnames.html Otherwise, try/catch mi...

11 months ago | 1

Answered
Error in XML file
You could try fid = fopen(fname); bytes = fread(fid); fclose(fid); find(bytes==1) If that doesn't find anything, then it ma...

12 months ago | 0

Answered
Does MATLAB add extra data to text files?
I'd check the new line characters "\r" isn't typically used for a new line in most modern environments. It may be that the tex...

12 months ago | 1

| accepted

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

1 year 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...

1 year 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...

1 year 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.)

1 year 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 ...

1 year 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...

1 year 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)

1 year 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...

1 year 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,...

1 year ago | 0

| accepted