real simple -- spreadsheet parsing

2020 3 27
2 个回答
回答已采纳
更新时间：2020 3 28
10 次查看（30 天）

0 个投票

got a spreadsheet with data like this , basically n by m matrix containing alpha-numerical values
i just want to reduce this to a numeric (double) matrix (2d array) containing only the middle number , i.e. the number that's in between the : and the (
like 1759, 1777,1755... the 4 digit number thats in the middle . i want to plot them out on a graph
the format is fixed
how do i do this

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

 采纳的回答

Walter Roberson
Walter Roberson 2020-3-27

0 个投票

You can use extractBetween() on the string array, and double() the result

更多回答（1 个）

chang liu
chang liu 2020-3-27

0 个投票

since the format is fixed i was thinking maybe easy way is to just say ignore the first 6 or so characters, ignore the last 7 characters?
i am using importdata() and then convert to string by doing string()

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by