Import data from CSV file by Import Tool or textscan

I can import data from csv file by Import Tool(out type:string), and the tool could creat a script(textscan in it) to instead Import Tool. But, when I use Import Tool or script to import csv file, it lost blank line which in csv file. How to solve it? Thanks.

4 Comments

Why do you want a blank line in your matrix? You can't have that in a double matrix. You can't have one row be blank (all nulls). Explain why you think you need this.
I want to read the data to check it, lost blank line will give me a wrong position. csv file contains string and number just like a excel, but read it by string is fine, so please don't care the data type.
Read about readtable to load csv file.
readtable lost blank line too,and variable name in csv file will be changed. It is boring.

Sign in to comment.

 Accepted Answer

In the script which Import Tool created, change
delimiter = ',';
to
delimiter = {',','\r'};
It seems to have been solved.

More Answers (1)

Use readmatrix() that would import all numerical data in a matrix form.

Products

Release

R2017b

Asked:

on 5 Nov 2021

Answered:

on 5 Nov 2021

Community Treasure Hunt

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

Start Hunting!