Results 1 to 1 of 1

process data in text file and import to worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2011
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    54

    process data in text file and import to worksheet

    Could somebody please help me with this,

    I have this kind of data in text file

    # 
    # MS.PreferredSpectrumFormat = 0
    # MS.UncentroidingHalfWidth = 0.02
    # MS.UncentroidingPointsPerDa = 40
    # MS.AlwaysUncentroid = 0
    # MS.RegriddingPointsPerDa = 200
    # MS.AggregationMethod = 1
    # MS.MinPeakCount = 1
    # MS.MinPeakCharge = 1
    # MS.MaxPeakCharge = 5
    # MSMS.PreferredSpectrumFormat = 0
    # MSMS.UncentroidingHalfWidth = 0.02
    # MSMS.UncentroidingPointsPerDa = 40
    # MSMS.AlwaysUncentroid = 0
    # MSMS.RegriddingPointsPerDa = 200
    # MSMS.AggregationMethod = 2
    # MSMS.MinPeakCount = 3
    # MSMS.MinPeakCharge = 1
    # MSMS.MaxPeakCharge = 2
    # MSMS.UsePrecursorAsMaxCharge = 1
    # MSMS.PrecursorChargeSources = 1
    # MSMS.PrecursorDefaultCharges = 1; 2; 3; 4; 5
    # MSMS.RedeterminePrecursorMZ = 1
    # MSMS.PrecursorMZTolerance = 2
    # MSMS.IgnoreSingleChargedPrecursor = 0
    # TimeDomain.MinPrecursorMass = 500
    # TimeDomain.MaxPrecursorMass = 5000
    # TimeDomain.PrecursorGroupingTolerance = 1
    # TimeDomain.MaxIntermediateTime = 0
    # TimeDomain.MaxIntermediateScans = 0
    # TimeDomain.UseIntermediateScanCount = 0
    # TimeDomain.MinScansInGroup = 1
    # TimeDomain.CollapseMSn = 0
    # PeakSelection.FilteringThreshold = 0.6
    # PeakSelection.MinFilteringPeakMZ = 250
    # PeakSelection.MaxFilteringPeakMZ = 1500
    # PeakSelection.FilteringMinSNRatio = 2
    # PeakSelection.MinPeakWidth = 0.005
    # PeakSelection.ExpectedPeakWidth = 0.05
    # PeakSelection.MaxPeakWidth = 0.13
    # PeakSelection.MaxIterations = 500
    # PeakSelection.RejectWidthOutliers = 0
    # PeakSelection.BaselineCorrection = 1
    # PeakSelection.BaselineSubtractMethod = 0
    # PeakSelection.PeakFitMethod = 0
    # PeakSelection.IsotopeEnvelopeMode = 0
    # PeakSelection.IsotopePeakIntensities = 
    # PeakSelection.SinglePeakCharge = 1
    # PeakSelection.SinglePeakWindow = 0
    # PeakSelection.MinSglPeakWindowMZ = 250
    # PeakSelection.MaxSglPeakWindowMZ = 350
    # 
    _DISTILLER_MDRO_VERSION=2.4.1.0
    _DISTILLER_RAWFILE={1}D:\MS_DATA\XL\2011\_XL2001----XL2100\XL2066_F1_01_553.d
    
    BEGIN IONS
    TITLE=1: Scan 2 (rt=1.16) [D:\MS_DATA\XL\2011\_XL2001----XL2100\XL2066_F1_01_553.d]
    PEPMASS=459.18009 35794472
    CHARGE=2+
    SCANS=2
    RAWSCANS=sn2
    RTINSECONDS=1.16
    281.05381	12465.077
    299.06492	10383.393
    324.99101	13885.746
    341.02195	25212.591
    359.03313	15421.499
    END IONS
    
    BEGIN IONS
    TITLE=2: Scan 11 (rt=11.345) [D:\MS_DATA\XL\2011\_XL2001----XL2100\XL2066_F1_01_553.d]
    PEPMASS=533.20132 50722404
    CHARGE=1+
    SCANS=11
    RAWSCANS=sn11
    RTINSECONDS=11.345
    281.05424	26256.861
    299.06482	24343.575
    326.96951	8122.2656
    341.02209	3983.679
    344.98034	9692.3164
    END IONS
    
    BEGIN IONS
    TITLE=3: Scan 18 (rt=19.279) [D:\MS_DATA\XL\2011\_XL2001----XL2100\XL2066_F1_01_553.d]
    PEPMASS=459.18006 35550492
    CHARGE=2+
    SCANS=18
    RAWSCANS=sn18
    RTINSECONDS=19.279
    281.05442	8886.7466
    299.0654	7308.4806
    324.99029	9926.7769
    341.02191	16512.901
    359.03335	9289.164
    END IONS
    
    .
    .
    .

    I want to import only the data marked in red color to worksheet in the pattern shown in the attached file.

    Please have a look at the data in the attached file.

    Any help would be highly appreciated.

    PS ref http://www.vbforums.com/showthread.p...10#post4127010
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1