Create numerical table from text file

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...

Answer 1

[TADA]

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

[Marisabel Gonzalez]

(Power\s*(\([^\)]+\))?))\s*=\s*(?<val>(\s*\d+(\.\d+)?)+)

uau.

Thank you for your help, this would be a great starting point!

[TADA]

cheers! good luck