B
Brian
Hello all.... We have a text file that gets dumped to our computer on a
daily basis with information in regards to our downtime/uptime etc. The way
the data comes in we can't change and it was first created just to be
printed off well now they want the information stored in the computer and
because of it's format (as in not comma delimted/tab etc.....) The only way
I can think of being able to grab the information is by doing a string
search or something like that within the file itself.... Example search for
the string "START" and then grab the next 15 characters and cut out the
space that comes behind it. All the importing I find for example code is
based on the text file having , | or tabs. I have searched an so far found
nothing. I want to search for multiple things in the text file assign those
to a variable and then import the values into a table.... Any examples
would be great. Below I provided just a partial look at what the text file
looks like the whole thing is 5 pages long. Many TIA
S********** Company NAME (Blah) (LEFT)
CORPORATION LOG STATISTICS (8-14') 16:31 MON
07/14/03
PRODUCTION PERIOD:
START: 06:00 MON 07/14/03
END: 16:30 MON 07/14/03
LOT #: 100
|------------------------- LENGTH -------------------------|
DIAM 8.0 8.5 9.0 9.5 10.0 10.5 11.0 11.5 12.0 12.5 13.0 13.5 14.0
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
4.0 2 0 0 0 0 0 0 0 0 0 0 0 0
8.5 0 0 0 0 1 0 0 0 1 0 0 0 0
9.0 0 1 0 0 0 0 0 0 0 2 0 0 0
9.5 0 1 0 0 3 0 1 2 2 2 1 0 1
10.0 1 1 0 0 0 2 0 1 2 2 3 0 0
10.5 2 1 0 0 2 6 0 1 2 1 0 0 0
11.0 7 5 0 0 3 1 0 3 2 0 2 0 0
11.5 2 8 3 1 1 2 0 0 2 1 2 0 1
daily basis with information in regards to our downtime/uptime etc. The way
the data comes in we can't change and it was first created just to be
printed off well now they want the information stored in the computer and
because of it's format (as in not comma delimted/tab etc.....) The only way
I can think of being able to grab the information is by doing a string
search or something like that within the file itself.... Example search for
the string "START" and then grab the next 15 characters and cut out the
space that comes behind it. All the importing I find for example code is
based on the text file having , | or tabs. I have searched an so far found
nothing. I want to search for multiple things in the text file assign those
to a variable and then import the values into a table.... Any examples
would be great. Below I provided just a partial look at what the text file
looks like the whole thing is 5 pages long. Many TIA
S********** Company NAME (Blah) (LEFT)
CORPORATION LOG STATISTICS (8-14') 16:31 MON
07/14/03
PRODUCTION PERIOD:
START: 06:00 MON 07/14/03
END: 16:30 MON 07/14/03
LOT #: 100
|------------------------- LENGTH -------------------------|
DIAM 8.0 8.5 9.0 9.5 10.0 10.5 11.0 11.5 12.0 12.5 13.0 13.5 14.0
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
4.0 2 0 0 0 0 0 0 0 0 0 0 0 0
8.5 0 0 0 0 1 0 0 0 1 0 0 0 0
9.0 0 1 0 0 0 0 0 0 0 2 0 0 0
9.5 0 1 0 0 3 0 1 2 2 2 1 0 1
10.0 1 1 0 0 0 2 0 1 2 2 3 0 0
10.5 2 1 0 0 2 6 0 1 2 1 0 0 0
11.0 7 5 0 0 3 1 0 3 2 0 2 0 0
11.5 2 8 3 1 1 2 0 0 2 1 2 0 1