How can I import a file.txt on excel using as delimiters the comma(,), the semicolon(;) and the underscore(_)?

2 ビュー (過去 30 日間)
I need to import a set of data of this form
1;2017-03-13_13-37-04;,5,0,0,3d,a2
I need the delimiters to be the comma(,), the underscore(_) and the semicolon(;). Basically I want the 1 to be on the first section of my excel page 2017-03-13 on the following section 13-37-04 on the third section and so on.
Thanks in advance

採用された回答

Walter Roberson
Walter Roberson 2017 年 3 月 18 日
Maybe
filecontent = fileread('YourFileName.txt');
parts = regexp(filecontent, '[,;_\n]', 'split');

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by