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 commentaires

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.
kei hin
kei hin le 5 Nov 2021
Modifié(e) : kei hin le 5 Nov 2021
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.
kei hin
kei hin le 5 Nov 2021
Modifié(e) : kei hin le 5 Nov 2021
readtable lost blank line too,and variable name in csv file will be changed. It is boring.

Connectez-vous pour commenter.

 Réponse acceptée

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

Plus de réponses (1)

Sulaymon Eshkabilov
Sulaymon Eshkabilov le 5 Nov 2021

0 votes

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

Produits

Version

R2017b

Community Treasure Hunt

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

Start Hunting!

Translated by