Readtable (file not getting detected in the directory)

11 次查看(过去 30 天)
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 个评论
Image Analyst
Image Analyst 2023-1-5
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.

请先登录,再进行评论。

采纳的回答

Walter Roberson
Walter Roberson 2023-1-5
Do not bother to rename the file. Instead, when you call readtable() give the option 'FileType', 'text'
  7 个评论
Image Analyst
Image Analyst 2023-1-5
编辑:Image Analyst 2023-1-5
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.

请先登录,再进行评论。

更多回答(1 个)

Fangjun Jiang
Fangjun Jiang 2023-1-5
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 个评论
Image Analyst
Image Analyst 2023-1-5
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.

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Environment and Settings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by