Readtable (file not getting detected in the directory)
10 views (last 30 days)
Show older comments
Ashishkumar Gupta
on 5 Jan 2023
Commented: Ashishkumar Gupta
on 5 Jan 2023
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 Comments
Image Analyst
on 5 Jan 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.
Accepted Answer
Walter Roberson
on 5 Jan 2023
Do not bother to rename the file. Instead, when you call readtable() give the option 'FileType', 'text'
7 Comments
Image Analyst
on 5 Jan 2023
Edited: Image Analyst
on 5 Jan 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.
More Answers (1)
Fangjun Jiang
on 5 Jan 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 Comments
Image Analyst
on 5 Jan 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.
See Also
Categories
Find more on Environment and Settings in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!