Trouble Importing from txt file

n00ber · Jun 4, 2012

Hi All

I am having trouble importing a text log into excel.

There are no delimiters in the log.
Also the number of spaces between titles is of variable length.

Also i cannot open the file as fixed width as all the columns are not the same size.

I am looking to extract various variables from different lines.

Code:

--- 338 (SE)  Unable to find this calconst name: SERIALNO 

--- 303 (SE)  request for non-existent calibration constant from the CALACTIV.DB file
New logfile started for system 0

%
------------------------------------------------------------

--- 2086 (SE) Error on sensor 5 17 -- Flags = 0a
scan interferometer power       -6.98 volts   8:00  4/9/2012
VOL barometric pressure         982.2 millibars   8:00  4/9/2012
Humidity sensor output          33.99 percent   8:00  4/9/2012
Stripe VOL thermistor           3486 A to D counts   8:00  4/9/2012
Scan VOL thermistor             2725 A to D counts   8:00  4/9/2012
AOM temp                        21.32 degrees C   8:00  4/9/2012
bridge temp at steering mirror  21.57 degrees C   8:00  4/9/2012
bridge right side temp          21.22 degrees C   8:00  4/9/2012
steering mirror temp            21.34 degrees C   8:00  4/9/2012
scan interferometer temp        21.21 degrees C   8:00  4/9/2012
stripe interferometer temp      21.46 degrees C   8:00  4/9/2012
stage top temp                  21.07 degrees C   8:00  4/9/2012
scan motor temp                 21.01 degrees C   8:00  4/9/2012
stripe motor temp               21.97 degrees C   8:00  4/9/2012
z motor  1 temp                 21.33 degrees C   8:00  4/9/2012
z motor  2 temp                 21.17 degrees C   8:00  4/9/2012
z motor  3 temp                 21.19 degrees C   8:00  4/9/2012
head temperature                26 degrees C   8:00  4/9/2012
polygon rear bearing temp       23.27 degrees C   8:00  4/9/2012
polygon front bearing temp      23.85 degrees C   8:00  4/9/2012
polygon air out temp            23.57 degrees C   8:00  4/9/2012
house water temp                9.47 degrees C   8:00  4/9/2012
laser water in temp             24.8 degrees C   8:00  4/9/2012
laser water out temp            41.36 degrees C   8:00  4/9/2012
drawer heat exchanger out temp  16.07 degrees C   8:00  4/9/2012
magnet current                  13.1 amps   8:00  4/9/2012
magnet voltage                  227 volts   8:00  4/9/2012
magnet resistance               21 ohms   8:00  4/9/2012
tube current                    48.2 amps   8:00  4/9/2012
tube voltage                    227 volts   8:00  4/9/2012
tube resistance                 21 ohms   8:00  4/9/2012
Coherent water flow             2.5 gallons per minute   8:00  4/9/2012
laser circulation water flow    0 gallons per minute   8:00  4/9/2012
environmental system water flow 0 gallons per minute   8:00  4/9/2012
electronics cooling water flow  0 gallons per minute   8:00  4/9/2012
polygon air press               92.07 psig   8:00  4/9/2012
air isolator press              -24.79 psig   8:00  4/9/2012
aligner float pressure          -13.16 psig   8:00  4/9/2012
focus sensor pressure           -24.79 psig   8:00  4/9/2012
vacuum supply                   -12.47 psig   8:00  4/9/2012
scan interferometer power       -6.98 volts   8:00  4/9/2012
stripe interferometer power     -6.87 volts   8:00  4/9/2012
humidity sensor power           3.6 volts   8:00  4/9/2012
VOL thermistor offset           126.21 D to A setting   8:00  4/9/2012
starting  JOBPREP 17, PH496427, zbd96427.jcl, P69997  8:00  4/9/2012
Using hardware zoom of 1.000.  8:01  4/9/2012
Option: parameter 2 = 1 is forced.
ONLY calculate zoom corrected focus with FOCTBL.
Skip both ZOOM correction and steering mirror gain update.
Foctable adjustment = -0.016 microns  8:01  4/9/2012
scalchg set Nominal Focus = 3217 [AF A/D cnts] as base focus at this zoom setting.  8:01  4/9/2012
BFC option is active
Set Focus (BFC:S2NMFOC:calactiv) = 3220 [AF A/D cnts]  8:01  4/9/2012
.      Uncorrected Focus (S2NMFOC:calperm) = 3217
.      Current pressure = 982.100
(BFC)  Nominal site pressure (NOMPRESS:calactiv)  = 1002.000
(BFC)  Co-efficient (ADPMBAR:calactiv)  = -0.200 [AF A/D cnts per mBar]
Using dose of 95.000 mJ/cm**2.  8:01  4/9/2012
Exposure table dose adjustment = 0.999, dose = 94.896.  8:01  4/9/2012
Laser set to 47.600 amps  8:01  4/9/2012
Setting facet detect PMT to 70 percent.  8:01  4/9/2012
Laser power set to 114.655 milliwatts.  8:01  4/9/2012
Facet period set to 141990 nanoseconds.  8:01  4/9/2012
Pixel period set to 21.500 nanoseconds.  8:01  4/9/2012
Stage velocity = 14.085 mm/sec  8:01  4/9/2012
Velocity of Light Values (Str, Scn) : 0.9999973 0.9999973.  8:02  4/9/2012
Plate on the arm: 0  Yes=1, No=0
After Leveling: Motor counts are: 189 43 4016  8:04  4/9/2012
copstr = 1.172500e+08  8:04  4/9/2012
copscn = 1.172500e+08  8:04  4/9/2012
pltsiz = 1.524000e+08  8:04  4/9/2012
afs2offs = 1.000000  8:04  4/9/2012
threshold value = 0  8:04  4/9/2012
Centrality (x, y, rot.) = 0.1  -0.1  0.1  8:05  4/9/2012
stage PZT OK  8:05  4/9/2012
steering mirror PZT OK  8:06  4/9/2012
do init2vg in pltsetup  8:06  4/9/2012
Enabling PHC filtering of VOL/barometer values
Sending following setup parameters to PHC:
EnableFlag 00000053 DummyPress 10180 PressTol 50
MaxMissedlPressCnt 60 MinStablePressCnt 4
MaxMissedVolCnt 1    MinStableVolCnt 5
VolTol 1.000000e-03

----------------------------------------

CGI6KLARR.0A 0.250000 Exact
DUMMYFILE.0K 0.062500 Exact
SPCTESTCE.LL 0.250000 Exact
YPH496427.23 0.062500 Exact
ZOOM_SETTING 1.00000000000

----------------------------------------

--- 2086 (SE) Error on sensor 5 17 -- Flags = 0f
scan interferometer power       -7.01 volts   9:06  4/9/2012
VOL barometric pressure         981.3 millibars   9:06  4/9/2012
Humidity sensor output          34.48 percent   9:06  4/9/2012
Stripe VOL thermistor           3496 A to D counts   9:06  4/9/2012
Scan VOL thermistor             2734 A to D counts   9:06  4/9/2012
bridge temp at steering mirror  21.57 degrees C   9:06  4/9/2012
head temperature                26 degrees C   9:06  4/9/2012
house water temp                10.13 degrees C   9:06  4/9/2012
laser water in temp             24.72 degrees C   9:06  4/9/2012
laser water out temp            41.18 degrees C   9:06  4/9/2012
magnet current                  13.1 amps   9:06  4/9/2012
tube current                    47.7 amps   9:06  4/9/2012
tube voltage                    226 volts   9:06  4/9/2012
scan interferometer power       -7.02 volts   9:06  4/9/2012
stripe interferometer power     -6.87 volts   9:06  4/9/2012

------------------------------------------------

Using hardware zoom of 1.000.  9:07  4/9/2012
Option: parameter 2 = 1 is forced.
ONLY calculate zoom corrected focus with FOCTBL.
Skip both ZOOM correction and steering mirror gain update.
Foctable adjustment = -0.016 microns  9:07  4/9/2012
scalchg set Nominal Focus = 3217 [AF A/D cnts] as base focus at this zoom setting.  9:07  4/9/2012
BFC option is active
Set Focus (BFC:S2NMFOC:calactiv) = 3221 [AF A/D cnts]  9:07  4/9/2012
.      Uncorrected Focus (S2NMFOC:calperm) = 3217
.      Current pressure = 981.200
(BFC)  Nominal site pressure (NOMPRESS:calactiv)  = 1002.000
(BFC)  Co-efficient (ADPMBAR:calactiv)  = -0.200 [AF A/D cnts per mBar]
Using dose of 103.000 mJ/cm**2.  9:07  4/9/2012
Exposure table dose adjustment = 0.999, dose = 102.887.  9:07  4/9/2012
Laser set to 48.200 amps  9:07  4/9/2012
Setting facet detect PMT to 69 percent.  9:07  4/9/2012
Laser power set to 124.310 milliwatts.  9:07  4/9/2012
Facet period set to 141899 nanoseconds.  9:07  4/9/2012
Pixel period set to 21.500 nanoseconds.  9:08  4/9/2012
Stage velocity = 14.095 mm/sec  9:08  4/9/2012
Velocity of Light Values (Str, Scn) : 0.9999970 0.9999971.  9:08  4/9/2012
Checking if a plate is on the arm ...
Plate on the arm: 0  Yes=1, No=0
New PAQ PMT setting is 77 percent.  9:09  4/9/2012
LFS changed by 9.670e-03 microns, TH0 changed by 0.017 mRad
Patsetup changed LFS to 1651061.136, TH0 to 1.391e-03.  9:12  4/9/2012
Laser set to 48.200 amps  9:12  4/9/2012
Setting facet detect PMT to 69 percent.  9:12  4/9/2012
Laser power set to 124.310 milliwatts.  9:12  4/9/2012
Facet period set to 141991 nanoseconds.  9:12  4/9/2012
Pixel period set to 21.500 nanoseconds.  9:12  4/9/2012
Stage velocity = 14.085 mm/sec  9:12  4/9/2012
Plate on the arm: 0  Yes=1, No=0
After Leveling: Motor counts are: 187 43 4053  9:15  4/9/2012
copstr = 1.172500e+08  9:15  4/9/2012
copscn = 1.172500e+08  9:15  4/9/2012
pltsiz = 1.524000e+08  9:15  4/9/2012
afs2offs = 1.000000  9:15  4/9/2012
threshold value = 0  9:15  4/9/2012
Centrality (x, y, rot.) = 0.1  -0.1  0.1  9:16  4/9/2012
stage PZT OK  9:17  4/9/2012
steering mirror PZT OK  9:17  4/9/2012
do init2vg in pltsetup  9:17  4/9/2012
Enabling PHC filtering of VOL/barometer values
Sending following setup parameters to PHC:
EnableFlag 00000053 DummyPress 10180 PressTol 50
MaxMissedlPressCnt 60 MinStablePressCnt 4
MaxMissedVolCnt 1    MinStableVolCnt 5
VolTol 1.000000e-03

----------------------------------------

CGI6KLARR.0A 0.250000 Exact
DUMMYFILE.0K 0.062500 Exact
SPCTESTCE.LL 0.250000 Exact
YPH496427.20 0.062500 Exact
ZOOM_SETTING 1.00000000000

-----------------------------------

Using hardware zoom of 1.000. 10:33  4/9/2012
Option: parameter 2 = 1 is forced.
ONLY calculate zoom corrected focus with FOCTBL.
Skip both ZOOM correction and steering mirror gain update.
Foctable adjustment = -0.016 microns 10:33  4/9/2012
scalchg set Nominal Focus = 3217 [AF A/D cnts] as base focus at this zoom setting. 10:33  4/9/2012
BFC option is active
Set Focus (BFC:S2NMFOC:calactiv) = 3221 [AF A/D cnts] 10:33  4/9/2012
.      Uncorrected Focus (S2NMFOC:calperm) = 3217
.      Current pressure = 979.900
(BFC)  Nominal site pressure (NOMPRESS:calactiv)  = 1002.000
(BFC)  Co-efficient (ADPMBAR:calactiv)  = -0.200 [AF A/D cnts per mBar]
Using dose of 95.000 mJ/cm**2. 10:33  4/9/2012
Exposure table dose adjustment = 0.999, dose = 94.896. 10:33  4/9/2012
Laser set to 47.600 amps 10:34  4/9/2012
Setting facet detect PMT to 70 percent. 10:34  4/9/2012
Laser power set to 114.655 milliwatts. 10:34  4/9/2012
Facet period set to 141991 nanoseconds. 10:34  4/9/2012
Pixel period set to 21.500 nanoseconds. 10:34  4/9/2012
Stage velocity = 14.085 mm/sec 10:34  4/9/2012
Velocity of Light Values (Str, Scn) : 0.9999967 0.9999967. 10:34  4/9/2012
Plate on the arm: 0  Yes=1, No=0
After Leveling: Motor counts are: 185 42 3989 10:37  4/9/2012
copstr = 1.172500e+08 10:37  4/9/2012
copscn = 1.172500e+08 10:37  4/9/2012
pltsiz = 1.524000e+08 10:37  4/9/2012
afs2offs = 1.000000 10:37  4/9/2012
threshold value = 0 10:37  4/9/2012
Centrality (x, y, rot.) = 0.1  -0.1  0.1 10:38  4/9/2012
stage PZT OK 10:38  4/9/2012
steering mirror PZT OK 10:38  4/9/2012
do init2vg in pltsetup 10:38  4/9/2012
Enabling PHC filtering of VOL/barometer values
Sending following setup parameters to PHC:
EnableFlag 00000053 DummyPress 10180 PressTol 50
MaxMissedlPressCnt 60 MinStablePressCnt 4
MaxMissedVolCnt 1    MinStableVolCnt 5
VolTol 1.000000e-03

-----------------------------------

CGI6KLARR.0A 0.250000 Exact
DUMMYFILE.0K 0.062500 Exact
SPCTESTCE.LL 0.250000 Exact
YPH496427.22 0.062500 Exact
ZOOM_SETTING 1.00000000000

This a rolling log.
I would be looking to record each iteration of a variables value, date and time.

I.e
VOL barometric pressure
scan motor temp
scalchg set Nominal Focus
Laser power
LFS
TH0
Centrality

I am really lost with this one and ANY help would be greatly appreciated.

s-h · Jun 6, 2012

As a start I would look at using Line Input to read each line of the file into an array.

Then use the Filter function to search the array for those strings above, then use Split, IsNumeric and IsDate functions to identify values.

Trouble Importing from txt file

n00ber

New Member

Excel Facts

s-h

New Member

Similar threads

Forum statistics

Share this page

Trouble Importing from txt file

n00ber

New Member

Excel Facts

s-h

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock