Differentiating between a binary column and a decimal column from dlmread data.

Hi all-

My program creates an array from dlmread data from a text file, and the file has any number of columns. Each of the columns either contains binary (ie. 10001) or decimal (ie 17.0) data. Is there a function, or an easy way I can determine which columns contain which type of data?

Thanks!

Answer 1

[Azzi Abdelmalek]

If you use dlmread to read your text file, and your file looks like

1001 2 4
0101 3 5
0001 5 6

a=dlmread('file.txt')

The result is

1001 2 4
101 3 5
1 5 6

Your binary numbers are modified

[Wade Warren]

Yah- I understand that- which is why I'm curious if there is any way to differentiate? Let me know, thanks!

[Azzi Abdelmalek]

don't use dlmread to read such files, you can use textscan function to read your data

fid=fopen('file.txt')
out=textscan(fid,'%s','delimiter','\n')
fclose(fid)
out=out{:}

[Wade Warren]

Alright- so if I use textscan, how would I differentiate the two types of data? Really appreciate your help!

[Azzi Abdelmalek]

If your file looks like

45 1001 2
65.3 0101 3.35
101 0011 2.65

The code

fid=fopen('file.txt')
out=textscan(fid,'%s','delimiter','\n')
fclose(fid)
out=out{:}
a=regexp(out,'[\.\d]*','match')
n=numel(a{1})
b=reshape([a{:}],n,[])'
c=regexp(b,'(1|0)+')
column=find(all(~cellfun(@isempty,c)))