Importing data from specific line

32 views (last 30 days)
David Kerres
David Kerres on 4 Nov 2019
Answered: Roshni Garnayak on 7 Nov 2019
Hey guys,
I have a very basic question. I have a .csv file containing a lot of information I don't want to import my myworkspace. The data I want to import to a table or matrix starts in line 46. How can I cut all the other data to just import the numbers out of the text file?
Hope you can help me,
David
  2 Comments
Guillaume
Guillaume on 4 Nov 2019
Some of the import functions such as textscan and readtable have an option to skip any number of header lines. However, the main issue is that your file is encoded in UTF16 which matlab doesn't officially support (a bit ironical since matlab use UTF16 internally!)
While matlab can still read the file, you'll always get a wall of warning messages if you do. Is there an option to get the file in another encoding (UTF8 ideally).
David Kerres
David Kerres on 4 Nov 2019
Thanks for your answer! I just found an option to get the .csv file without the parameterblock and in UFT8. Now it works. Thank you very much!

Sign in to comment.

Answers (1)

Roshni Garnayak
Roshni Garnayak on 7 Nov 2019
You can use the ‘readmatrix’function to import data from your .csvfile. To specify the range of data that you want to import, use the Name-Value pair argument ‘Range’ while calling the ‘readmatrix’ function.
For further details and examples on how to specify the range refer to the following documentation:

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!