MATLAB Answers

Column Headers from Imported Data

10 views (last 30 days)
Jonathan Rua
Jonathan Rua on 6 Nov 2019
Answered: Subhadeep Koley on 8 Nov 2019
When importing Data from an ASCII file, it only saves one row of text for the column headers but I would like it to save two rows of text as column headers. Both are tab delimited. How do I import the file with two rows of Column Headers?

  3 Comments

Bhaskar R
Bhaskar R on 6 Nov 2019
No text file attatched.
Have you tried the MATLAB command ?
importdata
Jonathan Rua
Jonathan Rua on 6 Nov 2019
Yes. That was the command I was using but the tab delimiter only works on the row above the data and not two rows above. I found that if I use the command:
readtable
then it will use the delimiter on that row but I have yet to see if it works for what I want.
Star Strider
Star Strider on 6 Nov 2019
In readtable, under Text Files Only, see the 'HeaderLines' name-value pair. (Cannot link directly to it.)

Sign in to comment.

Answers (1)

Subhadeep Koley
Subhadeep Koley on 8 Nov 2019
Hi, refer the example below.
filename = fullfile(matlabroot,'examples','matlab','myCsvTable.dat');
n = 2; % Number of rows to be skipped at the beginning
T = readtable(filename,'HeaderLines',n);
Hope this helps!

  0 Comments

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by