text file(s) of different sizes

lablover1

New Member
Joined
Mar 21, 2013
Messages
41
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. :confused:any advice? Thanks
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
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...
 
Upvote 0
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...
 
Upvote 0
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?! ;)
 
Upvote 0
<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..
 
Upvote 0
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...
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,268
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top