Extracting a number from certain line of .txt file

Hi everyone I have big .txt file and I want to extract the certain value

How can I extract and print the value written after "COLLAPSE MULTIPLIER=" into file.

[KSSV]

Attach your text file...image snippets will not allow us to copy and try it.

[Mohammad Mirza Hassan]

Hope this helps now. Thank you

Answer 1

[Paolo]

For the values which follow "COLLAPSE MULTIPLIER = ", you can simply use a positive lookbehind which checks for the pattern you indicated.

 file = fileread('collapsemultiplier.txt');
 match = regexp(file,'(?<=COLLAPSE\sMULTIPLIER\s=\s)(\d*.?\d*)','match');

match =

1×10 cell array

Columns 1 through 6

    {'1.945'}    {'3.594'}    {'4.648'}    {'5.361'}    {'5.898'}    {'6.360'}

Columns 7 through 10

    {'6.727'}    {'7.038'}    {'7.337'}    {'7.584'}

You can play around with it here.

[Mohammad Mirza Hassan]

How do I export the results into excel or txt file ?

[Paolo]

• Text file.

 fileID = fopen('collapsefile.txt','w');
 fprintf(fileID,'%s\n',match{:});
 fclose(fileID);

• Excel file.

 xlswrite('collapsefile.xlsx',match);

Please note that the filenames I chose are arbitrary and you can choose whatever you like.

[Mohammad Mirza Hassan]

You are a legend.

[Paolo]

Happy to help!

[Mohammad Mirza Hassan]

Thanks, the txt output is not organised. how I can have'em all in just say one column?

[Paolo]

Try opening the .txt file in Notepad ++.

[Mohammad Mirza Hassan]

Working perfect in Notepad++ .Cheers