Import text + data txt file into a matrix

2 次查看（过去 30 天）
Michele Rizzato
Michele Rizzato 2020-9-20
评论： Michele Rizzato 2020-9-25
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;;

请先登录，再回答此问题。

回答（1 个）

Madhav Thakker
Madhav Thakker 2020-9-23
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.

类别

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by