how to read from disk a text file containing columns of numbers and columns of characters

I have on disk a .txt file, containing

a column of dates (23/2/20) and, two columns of integers.

As an example, the first 3 lines look like that:

23/2/20 190 11000

24/2/20 310 90

25/2/20 15 14000

How to read this file from disk ?

Thanks !

Jack

[Geoff Hayes]

Jack - have you tried using importdata?

[Jack Cohen]

Not until now, but I can see I''ll do it ASAP !

Meanwhile, let me first to warmly thank you,for you help !

And also, could you solve for me the inverse problem:

Supposing I created in my editor a table file, containing 1 column of dates (12/05/2020 etc) and

3 columns of integers, how could I save this , as a disk file which can subsequently be printed ?

Thanks for your time and Best Regards,

Jack

Answer 1

[Guru Mohanty]

Hi, I understand you are trying to read data from a txt file and store processed data in another txt file. You can do this using the following functions.

1. importdata - To access data from a txt file
2. fopen - To create a new file
3. fprintf - To Write data in the text file.

Here is a sample code for it.

clc;clear all;
% File Read
filename = 'test.txt';
A = importdata(filename); 
Dates=A.textdata;
Column1=A.data(:, 1);
Column2=A.data(:, 1);
% File Write
fid = fopen( 'results.txt', 'wt' );
for i = 1:length(A.textdata)
  fprintf( fid, '%s %d %d\n', Dates{i}, Column1(i), Column2(i));
end
fclose(fid);