Import data from CSV file by Import Tool or textscan

2021 11 5
2 个回答
回答已采纳
更新时间：2021 11 5
16 次查看（30 天）

0 个投票

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 个评论
显示 2更早的评论 隐藏 2更早的评论

Image Analyst
Image Analyst 2021-11-5
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 2021-11-5
编辑：kei hin 2021-11-5
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.
KSSV
KSSV 2021-11-5
Read about readtable to load csv file.
kei hin
kei hin 2021-11-5
编辑：kei hin 2021-11-5
readtable lost blank line too,and variable name in csv file will be changed. It is boring.

请先登录，再进行评论。

请先登录，再回答此问题。

 采纳的回答

kei hin
kei hin 2021-11-5

0 个投票

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

更多回答（1 个）

0 个投票

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

类别

在 帮助中心 和 File Exchange 中查找有关 Text Files 的更多信息

产品

版本

R2017b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by