Column Headers from Imported Data

9 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
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!

Categories

Find more on Large Files and Big Data in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!