Info

This question is closed. Reopen it to edit or answer.

impport ia txt file into matlab

1 view (last 30 days)
Niki
Niki on 17 Jan 2013
Closed: MATLAB Answer Bot on 20 Aug 2021
*I have a file in text and I want to sort its information into a xls file the text file is as follows which each part starts with BEGIN IONS and end with END IONS *
BEGIN IONS
TITLE=445.1185_908.046
PEPMASS=445.1185
RTINSECONDS=908.046
CHARGE=1
355.074005126953 543
223.07470703125 59
150.026992797852 97
END IONS
BEGIN IONS
TITLE=610.1826_-1
PEPMASS=610.1826
RTINSECONDS=-1
CHARGE=1
END IONS
BEGIN IONS
TITLE=536.1563_-1
PEPMASS=536.1563
RTINSECONDS=-1
CHARGE=1
END IONS
BEGIN IONS
TITLE=519.1368_-1
PEPMASS=519.1368
RTINSECONDS=-1
CHARGE=1
END IONS
*and I want to save it as follows in a xls file *
TITLE PEPMASS RTINSECONDS CHARGE
445.1185_908.046 445.1185 908.046 1 355.074005126953 543 223.07470703125 59 150.026992797852 97
610.1826_-1 610.1826 -1 1
536.1563_-1 536.1563 -1 1
  1 Comment
Niki
Niki on 17 Jan 2013
no body knows ?

Answers (1)

Walter Roberson
Walter Roberson on 17 Jan 2013
read the file as a single string using fileread(). Use regexp() with named tokens to extract the desired information. Create a cell array from the resulting structure array. xlswrite() the cell array.
  3 Comments
Niki
Niki on 3 Feb 2013
do not work , I also tried with fopen(), then fscanf(), still the sam,e if you have any other suggestion please let me know

Community Treasure Hunt

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

Start Hunting!