MATLAB Answers

Import text + data txt file into a matrix

1 view (last 30 days)
Michele Rizzato
Michele Rizzato on 20 Sep 2020
Commented: Michele Rizzato on 25 Sep 2020
Good morning to all.
I have a complex txt file semicolon separated with both strings and numbers.
I wish to get a matrix to manipulate the content and operate matricial calculus in it.
Any idea how to operate?
I copy first two rows of the matrix here below but the overall file is more than 5000 rows.
Each row is divided in 15 columns (some of them empty). Just columns 3 4 5 10 12 13 are numbers, all the rest can be text.
Thank you very much
Michele
905856340;TRIAL1;00151250;00151250;00151250;0009;CASE1;1322;PROOF1;00002;7AA1A01;22;00125000;5021791709151;;
913769511;TRIAL2;00009150;00009150;00009150;0009;CASE2;1392;PROOF2;00002;7AC2C;22;00003230;5021791708536;;

  2 Comments

Mohammad Sami
Mohammad Sami on 22 Sep 2020
You can use either readtable or textscan
Michele Rizzato
Michele Rizzato on 25 Sep 2020
Thank you Mr. Sami, that was very helpful!

Sign in to comment.

Answers (1)

Madhav Thakker
Madhav Thakker on 23 Sep 2020
Hi Michele,
I understand that you want to read your data where each entry is separated by ';' and each row is separated by ';;'. readtable can be used to read data from text files into a matrix.
opts = detectImportOptions('yourTextFile.txt')
opts parameters can be changed to fit custom text files. You might want to look at Delimiter, LineEnding, VariableTypes to fit your needs.
opts.LineEnding = {';;'};
table = readtable('yourTextFile.txt', opts)
Hope this helps.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!