Read text without converting to date

I'm using both csvread and xlsread to read in a .csv file with hex data as text. Two of the values are '7DEC' and 'FEB6', but they are being auto-converted to '12/7/2023' and '2/6/2023' in the output cell. Is there a way to prevent this?

[Dyuman Joshi]

Use readtable instead both of the deprecated functions.

[Walter Roberson]

https://jenniferrpovey.medium.com/what-does-excel-and-an-incel-have-in-common-and-how-does-this-screw-with-science-902ac918e206

Answer 1

[Voss]

Try using readcell or readtable.

file = 'test.csv';

% show file contents:
type(file)

7DEC,FEB6

% read file into a cell array C:
C = readcell(file)

C = 1×2 cell array
    {'7DEC'}    {'FEB6'}

Answer 2

[dpb]

writematrix(["7DEC","FEB6","FFFE","ABCD"],'test.csv')
type test.csv

7DEC,FEB6,FFFE,ABCD

data=readcell('test.csv')

data = 1×4 cell array
    {'7DEC'}    {'FEB6'}    {'FFFE'}    {'ABCD'}

fid=fopen('test.csv','r');
data=textscan(fid,'%x','delimiter',',')

data = 1×1 cell array
    {4×1 uint64}

fid=fclose(fid)

fid = 0

data{:}

ans = 4×1

32236 65206 65534 43981

Depending upon whether you want it converted or not on input.

NOTA BENE: Both csvwrite and xlsread have long been deprecated...