csvread and dots in filename

Hello,

I know matlab script files don't accept filenames with many dots.

But my problem is different. I am trying to read a text file with csvread, and I get file not found error if the filename contains a dot other than the file extension separator.

I cannot rename these files because these files are generated and appended by another software. Renaming them breaks the updates.

How can I make csvread work?

Thanks

[Merged from duplicate]

I am really in trouble. fopen fails to open if filename contains @ symbol or extra . other than the one before file extension. I have so many files to load with these symbols.

I also tried csvread and dlmread, same problem.

Is there any other way to load files in Matlab?

Thanks

Answer 1

[Walter Roberson]

csvread() is a wrapper around dlmread() which in turn is a wrapper around textscan(). You could use textscan() directly.

[Cagdas Ozgenc]

Doesn't work. fopen itself fails if the filename contains an extra . or @ symbol.

[Walter Roberson]

Could you give an example?

Also which operating system and MATLAB version are you using?

[Cagdas Ozgenc]

I am trying on R2011b windows 8.

@AAE-I_INDEX_S&P Custom_ABN AMRO Renewable.csv

AZO_NYSE_Autozone Inc..CSV

Answer 2

[per isakson]

This works for me on R2012a 64bit

    >> fid = fopen( '@AAE-I_INDEX_S&P Custom_ABN AMRO Renewable.csv', 'r' );
    >> cac = textscan( fid, '%[^\n]' )
    cac = 
        {1x1 cell}
    >> cac{:}{:}
    ans =
    ?FROM 192.168.7.2:658161? 058 032 ...
    >>

and this too

    >> fid = fopen( 'AZO_NYSE_Autozone Inc..CSV', 'r' );
    >> cac = textscan( fid, '%[^\n]' )
    cac = 
        {1x1 cell}
    >> cac{:}{:}
    ans =
    ?FROM 192.168.7.2:658161? 058 032 055 ...
    >>

[Cagdas Ozgenc]

Which OS are you using?

[per isakson]

win7

[Cagdas Ozgenc]

OK Thanks. Then either it is OS or MATLAB version. I will try to find somebody with 2012a. If that also fails then it is an Windows 8 issue I suppose. When I rename the files by removing the symbols it reads just fine.

[Walter Roberson]

Works for me on R2012a on OS-X Lion.

[Cagdas Ozgenc]

Does MATLAB use Visual C++ Redistributable or some other C library? If so maybe I should upgrade the C library without touching Matlab.