Borrar filtros
Borrar filtros

Readtable (file not getting detected in the directory)

19 visualizaciones (últimos 30 días)
Hello All,
I am trying to import files with some weird extension like '.rec1066-5(4244)','.rec1067-5(4244)'.
The extension is taken care of changing it within the code to '.txt'
But some files are getting imported while some files with similar name and same type are NOT getting imported.
the error is:
Error using readtable
Unable to find or open 'C:\Users\ashis\OneDrive\Desktop\WS\a1.txt'. Check the path and filename or file permissions.
Please help me out!! Thanks!!!
I have added the screenshot now!!
I have added two sample files to be imported. Edited the data within due to some reasons!! but the extension is still same!!
  4 comentarios
Image Analyst
Image Analyst el 5 de En. de 2023
No you did not. Take 2 files with their original filenames, and zip them up into a zip file. Then attach the zip file with the paperclip icon to your reply.
Ashishkumar Gupta
Ashishkumar Gupta el 5 de En. de 2023
Hi @Image Analyst, please check now!! Thanks!

Iniciar sesión para comentar.

Respuesta aceptada

Walter Roberson
Walter Roberson el 5 de En. de 2023
Do not bother to rename the file. Instead, when you call readtable() give the option 'FileType', 'text'
  7 comentarios
Image Analyst
Image Analyst el 5 de En. de 2023
Editada: Image Analyst el 5 de En. de 2023
Like I said These text files are not of a form that can be understood by readtable. It doesn't make sense for fieldnames to have a dot in them, etc.
Opened in Notepad it looks like this:
Datum;Zeit;BO_ROT.Temp1;BO_ROT.Temp2; 64.75; 66.00; 66.25;****; 65.50;****; 67.75; 64.75; 66.25; 67.00; 0.00; 0.00; 0.00; 0.00; 0.00; 0.00; 0.00; 0.00; 0.00; 0.00; 0.00; 0.00; 0.00; 0.00; -0.25; -0.25; -0.80; -19.00; -0.50; -19.00; 0.25; 0.00; 0.25; 0.00; 64.75; 65.20; 66.48; 64.95; 66.25; 67.05; 19.00; 66.00; 19.00; 67.50; 64.75; 66.00; 67.00; 64.75; 65.20; 66.48; 64.70; 66.00; 66.25; 0.00; 65.50; 0.00; 67.75; 64.75; 66.25; 67.00; 1; 250; 10; 0; 80.0000; 80.0000; 256.8579; 443.5673
all in one line.
You'll have to write your own custom reader for them.

Iniciar sesión para comentar.

Más respuestas (1)

Fangjun Jiang
Fangjun Jiang el 5 de En. de 2023
It is not robust to change the file name or create new files in the script and expect to access it right away in the script.
insert a "rehash" line before read the file. see "doc rehash"
  6 comentarios
Image Analyst
Image Analyst el 5 de En. de 2023
These text files are not of a form that can be understood by readtable. You'll have to write your own custom reader for them.

Iniciar sesión para comentar.

Categorías

Más información sobre Environment and Settings en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by