text file(s) of different sizes

[lablover1]

Created a macro to bring in text files. Now the issue is that some of these text files are different sizes so that macro I created removing some of useless rows and columns will not work with every text file since they will be different. any advice? Thanks

 

[s hal]

Since there's nothing specific in what you're saying, I guess my theme would be to find what (similarly) makes them different and remove those areas. If you can't write a rule for what makes something unwanted, it will be impossible at best to write a macro to do it automatically down the road...

 

[lablover1]

The test runs vary from the length of time that the tests are run.. (this is for a lab).

 

[s hal]

I understand they vary, but what causes a row, column, etc. to be unwanted? I'm going to hazard a guess that you used the macro recorder to do something once and then realized that was the only time it actually worked... So I'm phrase this another way: are you able to define when things should happen using something other than the position? Code is flexible and can be made to fit many sizes, but rules should be rigid...

 

[lablover1]

ADVERTISEMENT

Unwanted text. I am trying to make it easier for the user to extract the actual data.

 

[s hal]

You're going to have to post something other than theory to get anywhere with this...

And I should hope its unwanted text, otherwise why remove it?!

 

[lablover1]

ADVERTISEMENT

LOL..ok, I will see what I can do (and have another cup of coffee)

 

[lablover1]

<PeakTrak Status=	8	CV=
<System x=	CombiFlash	/>
<FileVersion major=	1	minor=
<Units x=	1	/>
<RunDate x=	Friday 22 February 2013	/>
<RunTime x=	04:09PM	/>
<RunColumn x=	0	/>
<RediSep media=	1	size=
<CurrentCV x=	108.2317	/>
<ColumnGold x=	0	/>
<FlowRate x=	15	/>
<EqVol x=	7.3	/>
<AirPurge x=	0.5	/>
<InitWaste x=	0	/>
<Sensitivity x=	1	/>
<WV1On x=	1	/>
<WV1Wavelength x=	215	/>
<WV1ThresholdBased x=	1	/>
<WV1Threshold x=	0.2	/>
<WV1SlopeBased x=	1	/>
<WV1PeakWidth x=	2	/>
<WV1Gain x=	1	/>
<WV2On x=	1	/>
<WV2Wavelength x=	254	/>
<WV2ThresholdBased x=	0	/>
<WV2Threshold x=	0.2	/>
<WV2SlopeBased x=	0	/>
<WV2PeakWidth x=	2	/>
<WV2Gain x=	1	/>
<WVAllOn x=	0	/>
<WVAllThresholdBased x=	1	/>
<WVAllThreshold x=	0.2	/>
<WVAllSlopeBased x=	1	/>
<WVAllPeakWidth x=	2	/>
<WVAllGain x=	1	/>
<WVAllMinWavelength x=	200	/>
<WVAllMaxWavelength x=	780	/>
<ExtDetOn x=	0	/>
<ExtDetThresholdBased x=	1	/>
<ExtDetThreshold x=	0.05	/>
<ExtDetSlopeBased x=	1	/>
<ExtDetPeakWidth x=	2	/>
<ExtDetGain x=	1	/>
<ELSDOn x=	1	/>
<ELSDThresholdBased x=	1	/>
<ELSDThreshold x=	0.05	/>
<ELSDSlopeBased x=	1	/>
<ELSDPeakWidth x=	2	/>
<ELSDGain x=	1	/>
<ELSDSprayTemp x=	30	/>
<ELSDDriftTemp x=	60	/>
<RatioOn x=	0	/>
<Window1On x=	0	/>
<Window1Start x=	0	/>
<Window1End x=	0	/>
<Window1Collection x=	0	/>
<Window2On x=	0	/>
<Window2Start x=	0	/>
<Window2End x=	0	/>
<Window2Collection x=	0	/>
<Window3On x=	0	/>
<Window3Start x=	0	/>
<Window3End x=	0	/>
<Window3Collection x=	0	/>
<CollectionMethod x=	0	/>
<Vapor x=	36	/>
<TubeColPat x=	0	/>
<PeakTubeVol x=	10	/>
<NonPeakTubeVol x=	0	/>
<SampleName x=	4474-60-0	/>
<SolAReservoir x=	1	/>
<SolBReservoir x=	0	/>
<Notes></Notes>
<SolidSampleInjection x=	1	/>
<PrimeFlowPath x=	0	/>

<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
</TBODY>

Like this unwanted text..

 

[s hal]

But I'm not sure what makes any of this "unwanted text"... or what makes something I'm assuming is omitted in your post as "wanted text." So I'm unable to help without some more specifics...