real simple -- spreadsheet parsing

5 ビュー (過去 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 月 28 日
worked like a charm!

サインインしてコメントする。

その他の回答 (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 ExchangeData Type Conversion についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by