hunna
11-16-2011, 01:44 AM
Hello, if it's possible to import data from notepad file as shown below to excel worksheet
###FS: #m/z: 471.93765 #charge 3
###MaxRes:#m/z: 0.00000 #charge-128
###MS: 401/
###MSMS: 400/
BEGIN IONS
TITLE= Cmpd 1, +MSn(qCID 471.93765), 10.5 min
PEPMASS=471.937648 52884640
CHARGE=3+
471.241338 1994913 1+
1043.610977 869664 1+
1243.691115 1882480 1+
1300.713939 3368120 1+
1413.796382 2822475 1+
END IONS
###FS: #m/z: 784.05656 #charge 3
###MaxRes:#m/z: 0.00000 #charge-128
###MS: 402/405/
###MSMS: 403/407/
BEGIN IONS
TITLE= Cmpd 2, +MSn(qCID 784.05658), 10.6 min
PEPMASS=784.056557 52754752
CHARGE=3+
832.440915 316937 1+
2021.019465 394193 1+
2333.134355 291084 1+
2350.152226 260149 1+
END IONS
###FS: #m/z: 601.77318 #charge 4
###MaxRes:#m/z: 0.00000 #charge-128
###MS: 405/
###MSMS: 406/408/
BEGIN IONS
TITLE= Cmpd 3, +MSn(qCID 601.77319), 10.7 min
PEPMASS=601.773181 19070720
CHARGE=4+
646.341532 898599 1+
2404.067064 365217 1+
END IONS
In excel worksheet I want to keep only the red part (column A is m/z and D is charge number)
A B C D
471.9377 0 0 3
471.2413 1994913 1+
1043.611 869664 1+
1243.691 1882480 1+
1300.714 3368120 1+
1413.796 2822475 1+
784.0566 0 0 3
832.4409 316937 1+
2021.019 394193 1+
2333.134 291084 1+
2350.152 260149 1+
601.7732 0 0 4
646.3415 898599 1+
2404.067 365217 1+
I have a lot of data so I need macro to automate this work.
Any help would be appreciated.
###FS: #m/z: 471.93765 #charge 3
###MaxRes:#m/z: 0.00000 #charge-128
###MS: 401/
###MSMS: 400/
BEGIN IONS
TITLE= Cmpd 1, +MSn(qCID 471.93765), 10.5 min
PEPMASS=471.937648 52884640
CHARGE=3+
471.241338 1994913 1+
1043.610977 869664 1+
1243.691115 1882480 1+
1300.713939 3368120 1+
1413.796382 2822475 1+
END IONS
###FS: #m/z: 784.05656 #charge 3
###MaxRes:#m/z: 0.00000 #charge-128
###MS: 402/405/
###MSMS: 403/407/
BEGIN IONS
TITLE= Cmpd 2, +MSn(qCID 784.05658), 10.6 min
PEPMASS=784.056557 52754752
CHARGE=3+
832.440915 316937 1+
2021.019465 394193 1+
2333.134355 291084 1+
2350.152226 260149 1+
END IONS
###FS: #m/z: 601.77318 #charge 4
###MaxRes:#m/z: 0.00000 #charge-128
###MS: 405/
###MSMS: 406/408/
BEGIN IONS
TITLE= Cmpd 3, +MSn(qCID 601.77319), 10.7 min
PEPMASS=601.773181 19070720
CHARGE=4+
646.341532 898599 1+
2404.067064 365217 1+
END IONS
In excel worksheet I want to keep only the red part (column A is m/z and D is charge number)
A B C D
471.9377 0 0 3
471.2413 1994913 1+
1043.611 869664 1+
1243.691 1882480 1+
1300.714 3368120 1+
1413.796 2822475 1+
784.0566 0 0 3
832.4409 316937 1+
2021.019 394193 1+
2333.134 291084 1+
2350.152 260149 1+
601.7732 0 0 4
646.3415 898599 1+
2404.067 365217 1+
I have a lot of data so I need macro to automate this work.
Any help would be appreciated.