MATLAB: Dot and tab delimiting

data import

Hi, I am trying to import data files that have multiple delimiters. For example, the first data line is: 1.3001 3.5602 Importing the data file and using tab delimited give me column 1 of 1.3001 and column 2 of 3.5602. This is fine, as the second column is actually the decimal number of 3.5602. However, column 1 needs split up into a column that would include 1 and a column that would include 3001. Simply trying to use both tab and '.' delimiting will give me four columns, of 1, 3001, 3, and 5602; I need 3 columns of 1, 3001, and 3.5602. Any suggestions?

Best Answer

Here is an example of using dot delimiter:

a = 599.666;
b = num2str(a);
c = strsplit(b, '.');
first_element = str2num(c{1})
second_element = str2num(c{2})

Related Solutions

MATLAB: Dlmwrite problem

See help dlmwrite: This function is though to export matrices, but not cell strings. You can use fprintf instead fpr the header:

outfile = '/path/to/file/output.txt';
header={'feat1','feat2','feat3','feat4','feat5'};
data = magic(5);
fid = fopen(outfile, 'w');
if fid == -1; error('Cannot open file: %s', outfile); end
fprintf(fid, '%s\t', header{:});
fprintf(fid, '\n');
fclose(fid);
dlmwrite(outfile,data,'delimiter','\t','-append');

BTW. you can use fprintf directly for the data also instead of dlmwrite:

Fmt = [repmat('%g\t', size(data, 2)), '\n'];
fprintf(fid, Fmt, transpose(data));
fclose(fid);

This is faster than closing the file and re-opening it for appending through dlmwrite.

MATLAB: How to read a specific row of data using Textscan

Try this. See the documentation of the textscan to understand these statements.

f = fopen('test.txt');
columns = textscan(f, '%s', 12, 'HeaderLines', 11);
columns = columns{1}(2:11);
fclose(f);

Best Answer

Related Solutions

MATLAB: Dlmwrite problem

MATLAB: How to read a specific row of data using Textscan

Related Question