Create numerical table from text file

2 次查看(过去 30 天)
Here I attached one file from which I want to extract some values and place them on a table. Example, let's say I want the Elsasser Number, the Power and the Lorentz number. How would I look for those paricular keywords and extract the values and place them on a table with headlines?
I have several files similar to this one so it would be really painful to manually set up the table. Therefore I would need a loop...

采纳的回答

TADA
TADA 2018-12-17
text = fileread('example.txt');
% extract data
match = regexpi(text, '(?<key>(Elsasser\s*Number)|(Lorentz\s*Number)|(Power\s*(\([^\)]+\))?))\s*=\s*(?<val>(\s*\d+(\.\d+)?)+)', 'names')
match =
1×3 struct array with fields:
key
val
% display struct content to command window
struct2table(match, 'AsArray', true)
ans =
3×2 table
key val
______________________ __________________________
'Elsasser Number' '0.309188 0.309188'
'Lorentz Number' '0.001758'
'Power (eq 21 of C&A)' '20299.521762'
I used a regular expression to extract the data into a struct array containing a key-value pair
It's worth mentioning that this regexp works for the supplied file, but may break for other examples
regular expressions are very useful for such tasks, and to better understand, I suggest you search in google for a regular expression builder. most of them are good enough. some have very good teaching modules which help you learn how to write expressions
  2 个评论
Marisabel Gonzalez
Marisabel Gonzalez 2018-12-17
(Power\s*(\([^\)]+\))?))\s*=\s*(?<val>(\s*\d+(\.\d+)?)+)
uau.
Thank you for your help, this would be a great starting point!

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Characters and Strings 的更多信息

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by