real simple -- spreadsheet parsing

8 次查看（过去 30 天）
chang liu
chang liu 2020-3-27
评论： chang liu 2020-3-28
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
You can use extractBetween() on the string array, and double() the result

更多回答（1 个）

chang liu
chang liu 2020-3-27
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()

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by