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 Kommentare

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

Melden Sie sich an, um zu kommentieren.

 Akzeptierte Antwort

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

Weitere Antworten (1)

Sulaymon Eshkabilov
Sulaymon Eshkabilov am 5 Nov. 2021

0 Stimmen

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

Produkte

Version

R2017b

Gefragt:

am 5 Nov. 2021

Beantwortet:

am 5 Nov. 2021

Community Treasure Hunt

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

Start Hunting!

Translated by