MATLAB: Importing csv file with scientific notation

csvimportMATLAB and Simulink Student Suitetext file

I am having a lot of trouble importing my csv files, I have tried: importdata, dlmread and textscan. Just cant seem to get it working.
I have 100+ files, so changing them manually is tricky
when using importdata the result end up as a cell aray: {' – 6 . 5 9 9 4 8 E – 0 0 1 , – 4 . 8 6 2 2 6 E + 0 0 4 , – 6 . 5 9 9 4 8 E – 0 0 1 , 3 . 8 2 3 7 5 E + 0 0….'}

Best Answer

Unfortunately, none of the high-level functions work with UTF16, so you have to go low-level. Even then, you'll get a warning that the encoding is not supported. As of R2019a, I'm not aware of instances where it's not decoded properly, but: here be dragons. If you can change the setting of your exporting tool.
fid = fopen('test.csv', 'rt', 'n', 'UTF16LE');  %Issues a warning that UTF16 is not supported
data = textscan(fid, repmat('%f', 1, 12), 'Delimiter', ',', 'HeaderLines', 6);  %Same warning again
data = [data{:}]
fclose(fid);
Related Question