Multiple delimiters for readtable

33 Ansichten (letzte 30 Tage)
Pareil
Pareil am 11 Jun. 2019
Kommentiert: Star Strider am 11 Jun. 2019
Hello,
the data is stored in a text file like this:
Nb11(tab)Nb12 + Nb13 Nb14 + Nb15 Nb16 + Nb17
Nb21(tab)Nb22 + Nb23 Nb24 + Nb25 Nb26 + Nb27
I've tried to use the readtable command:
t = readtable('data.txt','Delimiter','tab +', MultipleDelimsAsOne, true)
and I obtain 4 columns instead of 7:
Nb11Nb12 Nb13Nb14 Nb15Nb16 Nb17
Do you have any suggestions in order to obtain 7 columns?
Thanks

Akzeptierte Antwort

Star Strider
Star Strider am 11 Jun. 2019
To specify more than one delimiter, use a cell array of character vectors:
t = readtable('data.txt','Delimiter',{'tab', '+'}, MultipleDelimsAsOne, true)
  2 Kommentare
Pareil
Pareil am 11 Jun. 2019
Thanks for the reply, it works.
However, 'tab' is not taken into account when there are more delimiters, works fine by replacing it by '\t'.
Star Strider
Star Strider am 11 Jun. 2019
As always, my pleasure.
I always use the character string designations, such as '\t', for the delimiters.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Cell Arrays finden Sie in Help Center und File Exchange

Produkte


Version

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by