2 questions

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Message
Author
sfournier
Posts: 43
Joined: 21 May 2013 12:38

2 questions

#1 Post by sfournier » 27 Jul 2015 12:30

Hello all,
You have all been a great resource before I'm hopeful you can help again.

I'm looking for 2 or more bits of coding to add to a script.

1.a. Filter out any lines that date is not with the range of today through T+2.
1.b. send the filtered out lines to a separate file for review
2. create a notification of some kind that this may have occurred.

My current process is 1 bat file that pulls 4 other different bat files. 3 of which are identical just looking for different file extensions. The 4th file just moves the original file to an archive folder.

I was thinking this would probably be a new bat file to do the separation. Coding posted below of the files.

Thank you for any and all information. the original file must keep all data in the specific character positions.

Steven

Original file example

Code: Select all

XXXXX,XXXXXXX                  MN-1E      MN1E-101-1     XXXXXXXXXX MNO        003300     20150728 2100         1 XXXXXXXXXX  MN-1E1    


Separation Bat File

Code: Select all

set local
set "filepath=M:\Pharmacy\PACMED\Pacmed Sep Script"

start /wait cmd /c "%filepath%\Data\extractmeds.bat"
start /wait cmd /c "%filepath%\Data\extractxo.bat"
start /wait cmd /c "%filepath%\Data\extracttxt.bat"

start /wait cmd /c "%filepath%\Data\moveoriginal.bat"


Extract Bat file

Code: Select all

setlocal enabledelayedexpansion

set "filepath=M:\Pharmacy\PACMED\"

set "ffile=%filepath%\Meditech extracts\*.txt"
set "fsearch=M:\pharmacy\pacmed\Pacmed Sep Script\Data\Narc_tabs.txt"
  set TmpFile="%temp%.\tmp.vbs"
  echo>>%TmpFile% n=Now
  echo>>%TmpFile% With WScript
  echo>>%TmpFile% .Echo "set m1="   + monthname(month(n), true)
  echo>>%TmpFile% .Echo "set m2="   + monthname(month(n), false)
  echo>>%TmpFile% .Echo "set woy="  + CStr(datepart("ww", n))
  echo>>%TmpFile% .Echo "set year=" + CStr(Year(n))
  echo>>%TmpFile% .Echo "set yr="   + Right(Year(n),2)
  echo>>%TmpFile% .Echo "set month="+ Right(100+Month(n),2)
  echo>>%TmpFile% .Echo "set day="  + Right(100+Day(n),2)
  echo>>%TmpFile% .Echo "set hour=" + Right(100+Hour(n),2)
  echo>>%TmpFile% .Echo "set min="  + Right(100+Minute(n),2)
  echo>>%TmpFile% .Echo "set sec="  + Right(100+Second(n),2)
  echo>>%TmpFile% .Echo "set dow="  + WeekDayName(Weekday(n),1)
  echo>>%TmpFile% .Echo "set dow2=" + WeekDayName(Weekday(n))
  echo>>%TmpFile% .Echo "set iso="  + CStr(1 + Int(n-2) mod 7)
  echo>>%TmpFile% .Echo "set iso2=" + CStr(Weekday(n,2))
  echo>>%TmpFile% End With
  cscript //nologo "%temp%.\tmp.vbs" > "%temp%.\tmp.bat"
  call "%temp%.\tmp.bat"
  del  "%temp%.\tmp.bat"
  del  %TmpFile%
  set TmpFile=

set "filenum=%day%%month%%year%"

set "num=0"

for %%z in ("%ffile%") do (
set "name="
set /p "name=" < "%%z"
set "name=!name:~31,5!


set /a num=num+1


findstr /lg:"%fsearch%" "%%z">>"%filepath%\Meditech extracts\Narcotics\donotdelete\!name!-%filenum%-Narc.txt"
findstr /lvg:"%fsearch%" "%%z">>"%filepath%\Meditech extracts\Pacmed\donotdelete\!name!-%filenum%-Pacmed.txt"
)
move /y "%filepath%\Meditech extracts\Narcotics\donotdelete\*txt*" "%filepath%\Meditech extracts\Narcotics\"
move /y "%filepath%\Meditech extracts\Pacmed\donotdelete\*txt*" "%filepath%\Meditech extracts\Pacmed\"

Copy "%filepath%\Meditech extracts\Pacmed\*.txt" "%filepath%\Meditech extracts\Archives\Pacmed\"
Copy "%filepath%\Meditech extracts\Narcotics\*.txt" "%filepath%\Meditech extracts\Archives\Narcotics\"


Archive Bat file

Code: Select all

set local

set "filepath=M:\Pharmacy\PACMED\Meditech extracts"

Move "%filepath%\*.meds" "%filepath%\Archives\Original\"
Move "%filepath%\*.xo" "%filepath%\Archives\Original\"
Move "%filepath%\*.txt" "%filepath%\Archives\Original\"

foxidrive
Expert
Posts: 6031
Joined: 10 Feb 2012 02:20

Re: 2 questions

#2 Post by foxidrive » 27 Jul 2015 20:47

Are you saying that you want to redirect the information from a file
and in your example the lines do not contain these numbers,
and the top one is today's date?

20150728
20150729
20150730


The following code will give you the dates, and the findstr line at the bottom is an example of how it can be used.

Code: Select all

@echo off
echo  >"%temp%\%~n0.vbs" s1=DateAdd("d",0,now)
echo >>"%temp%\%~n0.vbs" s2=DateAdd("d",1,now)
echo >>"%temp%\%~n0.vbs" s3=DateAdd("d",2,now)
echo >>"%temp%\%~n0.vbs" WScript.Echo "1 "^&year(s1)^& right(100+month(s1),2)^& right(100+day(s1),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "2 "^&year(s2)^& right(100+month(s2),2)^& right(100+day(s2),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "3 "^&year(s3)^& right(100+month(s3),2)^& right(100+day(s3),2)
for /f "tokens=1,2" %%a in ('cscript /nologo "%temp%\%~n0.vbs"') do set "day%%a=%%b"
del "%temp%\%~n0.vbs"
echo "%day1%" "%day2%" "%day3%"
findstr /v "%day1% %day2% %day3%" "filename1" > "filename2" && echo "filename2" has been created
pause

sfournier
Posts: 43
Joined: 21 May 2013 12:38

Re: 2 questions

#3 Post by sfournier » 28 Jul 2015 10:11

Hi Foxidrive,
Thank you for the quick response.
you are correct, i want to redirect the information from a file that do not fall with the set date range. The range would be today, tomorrow and the day after.

I will test the code and see if it works.

Thanks

sfournier
Posts: 43
Joined: 21 May 2013 12:38

Re: 2 questions

#4 Post by sfournier » 28 Jul 2015 10:30

Hi Foxidrive,
The code is working, but 2 concerns.
It is adding the original file name to the beginning of the copied code, this will cause errors in the program that reads the file, it also does not create a file with the good dates.

Both of these are my fault for not explaining completely the requirements, so thank you very much for the coding so far.

The current bat files i'm using, create 1 file based on matching strings of numbers, anything that matches goes into FILE1 and the ones that dont go to FILE2.
I was envisioning this to be the same, good date range items go to FILE1 bad date range files go to FILE2.

I would then copy/move the original into an archive folder, and then separate based on the matching string code that is currently working.

I'm not sure if that is making sense. Going to try to organize it better.
Steps below, more for my thoughts, hopefully helps clarify as well.

1. Original File created
2. Date Range separation applied > 2 new files created > Good dates > Bad dates
3. Original file now archived (This code i already have)
4. Good date file has the String Separation applied > 2 files created > Match > non match (This code i already have)
5. Good date now archived (This code i already have)

Thanks,
Steve

sfournier
Posts: 43
Joined: 21 May 2013 12:38

Re: 2 questions

#5 Post by sfournier » 28 Jul 2015 11:00

Update
*edited to include latest update*

I was able to get the 2 files created and the filename removed from both of the files.
Is there a way to get the "Pause" to only happen IF there is something created in the "Outside date.txt" file?

Code used below.

Code: Select all

@echo off

set "filepath=M:\Pharmacy\PACMED\test\"
set "ffile=%filepath%\meditech extracts\*.xo"

echo  >"%temp%\%~n0.vbs" s1=DateAdd("d",0,now)
echo >>"%temp%\%~n0.vbs" s2=DateAdd("d",1,now)
echo >>"%temp%\%~n0.vbs" s3=DateAdd("d",2,now)
echo >>"%temp%\%~n0.vbs" WScript.Echo "1 "^&year(s1)^& right(100+month(s1),2)^& right(100+day(s1),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "2 "^&year(s2)^& right(100+month(s2),2)^& right(100+day(s2),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "3 "^&year(s3)^& right(100+month(s3),2)^& right(100+day(s3),2)
for /f "tokens=1,2" %%a in ('cscript /nologo "%temp%\%~n0.vbs"') do set "day%%a=%%b"
del "%temp%\%~n0.vbs"
echo "%day1%" "%day2%" "%day3%"


for %%i in ("%ffile%") do (



findstr /lvg "%day1% %day2% %day3%" "%%i" >> "%filepath%Outside date.txt" && echo "Outside date.txt" has been created
findstr /lg "%day1% %day2% %day3%" "%%i" >> "%filepath%inside date.txt"
)
pause

foxidrive
Expert
Posts: 6031
Joined: 10 Feb 2012 02:20

Re: 2 questions

#6 Post by foxidrive » 28 Jul 2015 11:27

Delete the output files and test this. I made a logic error in my earlier code.

It's not an efficient code, but it's more straightforward for future changes,
and will work fast enough unless you have zillions of files.

Code: Select all

@echo off
set "filepath=M:\Pharmacy\PACMED\test\"
set "ffile=%filepath%\meditech extracts\*.xo"

echo  >"%temp%\%~n0.vbs" s1=DateAdd("d",0,now)
echo >>"%temp%\%~n0.vbs" s2=DateAdd("d",1,now)
echo >>"%temp%\%~n0.vbs" s3=DateAdd("d",2,now)
echo >>"%temp%\%~n0.vbs" WScript.Echo "1 "^&year(s1)^& right(100+month(s1),2)^& right(100+day(s1),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "2 "^&year(s2)^& right(100+month(s2),2)^& right(100+day(s2),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "3 "^&year(s3)^& right(100+month(s3),2)^& right(100+day(s3),2)
for /f "tokens=1,2" %%a in ('cscript /nologo "%temp%\%~n0.vbs"') do set "day%%a=%%b"
del "%temp%\%~n0.vbs"
echo "%day1%" "%day2%" "%day3%"

for %%i in ("%ffile%") do (

findstr /v "%day1% %day2% %day3%" "%%i" >nul || (
   type "%%i" >> "%filepath%Outside date.txt"
echo "Outside date.txt" has been created
)

findstr /v "%day1% %day2% %day3%" "%%i" >nul && (
   type "%%i" >> "%filepath%inside date.txt"
)

)
pause

sfournier
Posts: 43
Joined: 21 May 2013 12:38

Re: 2 questions

#7 Post by sfournier » 28 Jul 2015 12:15

Hi Foxidrive,
The original code works. the largest file that would go through this program would only be approximaltely 360kb and at most there would be 3 files.

My only problem now, well 2 problems, is ideally the PAUSE would only occur when the Outside date file contains data. And the code i used to name the files previously, does not seem to be renaming the files correctly now.

I'm putting the full code i'm trying now below.
What should be happening is the code will look at the first line, character 31 and the subsequent 5 characters and output this to be the !name! variable.
As well keep the files separate, so if there are 3 ORIGINAL files, there will be 3 files with "inside date" and 3 "outside date"
However upon completion of the script the output is just one combined file with the names "!name!-28072015-inside date.txt" and "!name!-28072015-Outside date.txt"

Any thoughts on what I screwed up?

Code: Select all

@echo off

set "filepath=M:\Pharmacy\PACMED\"
set "ffile=%filepath%\test\meditech extracts\*.xo"
echo  >"%temp%\%~n0.vbs" s1=DateAdd("d",0,now)
echo >>"%temp%\%~n0.vbs" s2=DateAdd("d",1,now)
echo >>"%temp%\%~n0.vbs" s3=DateAdd("d",2,now)
echo >>"%temp%\%~n0.vbs" WScript.Echo "1 "^&year(s1)^& right(100+month(s1),2)^& right(100+day(s1),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "2 "^&year(s2)^& right(100+month(s2),2)^& right(100+day(s2),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "3 "^&year(s3)^& right(100+month(s3),2)^& right(100+day(s3),2)
for /f "tokens=1,2" %%a in ('cscript /nologo "%temp%\%~n0.vbs"') do set "day%%a=%%b"
del "%temp%\%~n0.vbs"
echo "%day1%" "%day2%" "%day3%"

  set TmpFile="%temp%.\tmp.vbs"
  echo>>%TmpFile% n=Now
  echo>>%TmpFile% With WScript
  echo>>%TmpFile% .Echo "set m1="   + monthname(month(n), true)
  echo>>%TmpFile% .Echo "set m2="   + monthname(month(n), false)
  echo>>%TmpFile% .Echo "set woy="  + CStr(datepart("ww", n))
  echo>>%TmpFile% .Echo "set year=" + CStr(Year(n))
  echo>>%TmpFile% .Echo "set yr="   + Right(Year(n),2)
  echo>>%TmpFile% .Echo "set month="+ Right(100+Month(n),2)
  echo>>%TmpFile% .Echo "set day="  + Right(100+Day(n),2)
  echo>>%TmpFile% .Echo "set hour=" + Right(100+Hour(n),2)
  echo>>%TmpFile% .Echo "set min="  + Right(100+Minute(n),2)
  echo>>%TmpFile% .Echo "set sec="  + Right(100+Second(n),2)
  echo>>%TmpFile% .Echo "set dow="  + WeekDayName(Weekday(n),1)
  echo>>%TmpFile% .Echo "set dow2=" + WeekDayName(Weekday(n))
  echo>>%TmpFile% .Echo "set iso="  + CStr(1 + Int(n-2) mod 7)
  echo>>%TmpFile% .Echo "set iso2=" + CStr(Weekday(n,2))
  echo>>%TmpFile% End With
  cscript //nologo "%temp%.\tmp.vbs" > "%temp%.\tmp.bat"
  call "%temp%.\tmp.bat"
  del  "%temp%.\tmp.bat"
  del  %TmpFile%
  set TmpFile=

set "filenum=%day%%month%%year%"

set "num=0"

for %%z in ("%ffile%") do (
set "name="
set /p "name=" < "%%z"
set "name=!name:~31,5!



set /a num=num+1


findstr /lvg "%day1% %day2% %day3%" "%%z">>"%filepath%\test\!name!-%filenum%-Outside date.txt" && echo "Outside date.txt" has been created
findstr /lg "%day1% %day2% %day3%" "%%z">>"%filepath%\test\!name!-%filenum%-inside date.txt"
)
pause

foxidrive
Expert
Posts: 6031
Joined: 10 Feb 2012 02:20

Re: 2 questions

#8 Post by foxidrive » 28 Jul 2015 13:55

See if this works for you, but it doesn't do as you asked, does it?

Code: Select all

@echo off
setlocal enabledelayedexpansion

set "filepath=M:\Pharmacy\PACMED\"
set "ffile=%filepath%\test\meditech extracts\*.xo"
echo  >"%temp%\%~n0.vbs" s1=DateAdd("d",0,now)
echo >>"%temp%\%~n0.vbs" s2=DateAdd("d",1,now)
echo >>"%temp%\%~n0.vbs" s3=DateAdd("d",2,now)
echo >>"%temp%\%~n0.vbs" WScript.Echo "1 "^&year(s1)^& right(100+month(s1),2)^& right(100+day(s1),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "2 "^&year(s2)^& right(100+month(s2),2)^& right(100+day(s2),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "3 "^&year(s3)^& right(100+month(s3),2)^& right(100+day(s3),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "4 "^&right(100+day(s1),2)^& right(100+month(s1),2)^&year(s1)
for /f "tokens=1,2" %%a in ('cscript /nologo "%temp%\%~n0.vbs"') do set "day%%a=%%b"
del "%temp%\%~n0.vbs"
echo "%day1%" "%day2%" "%day3%"

set "filenum=%day4%"
set "num=0"

for %%z in ("%ffile%") do (
set "name="
set /p "name=" < "%%z"
set "name=!name:~31,5!

set /a num=num+1

findstr /v "%day1% %day2% %day3%" "%%z">>"%filepath%\test\!name!-%filenum%-Outside date.txt" && (echo "Outside date.txt" has been created & pause)
findstr "%day1% %day2% %day3%" "%%z">>"%filepath%\test\!name!-%filenum%-inside date.txt"
)

sfournier
Posts: 43
Joined: 21 May 2013 12:38

Re: 2 questions

#9 Post by sfournier » 29 Jul 2015 12:55

Hi Foxidrive,
You are correct, the change to this did not accomplish what i was looking for.
I do have 2 questions.
1. if we go back to the code that i have that is working, can we change the 3rd day to be 2359 instead of NOW? And I need to keep the files separate if there are multiple originals in the folder.
Some of the time stamps for the 3rd day may occur after the NOW time.
Previously we used the "set num=0" and then "set a/ num=num+1"

Code: Select all

@echo off

set "filepath=M:\Pharmacy\PACMED\test\"
set "ffile=%filepath%\meditech extracts\*.xo"

echo  >"%temp%\%~n0.vbs" s1=DateAdd("d",0,now)
echo >>"%temp%\%~n0.vbs" s2=DateAdd("d",1,now)
echo >>"%temp%\%~n0.vbs" s3=DateAdd("d",2,now)
echo >>"%temp%\%~n0.vbs" WScript.Echo "1 "^&year(s1)^& right(100+month(s1),2)^& right(100+day(s1),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "2 "^&year(s2)^& right(100+month(s2),2)^& right(100+day(s2),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "3 "^&year(s3)^& right(100+month(s3),2)^& right(100+day(s3),2)
for /f "tokens=1,2" %%a in ('cscript /nologo "%temp%\%~n0.vbs"') do set "day%%a=%%b"
del "%temp%\%~n0.vbs"
echo "%day1%" "%day2%" "%day3%"

for %%i in ("%ffile%") do (

findstr /lvg "%day1% %day2% %day3%" "%%i" >> "%filepath%Outside date.txt" && echo "Outside date.txt" has been created
findstr /lg "%day1% %day2% %day3%" "%%i" >> "%filepath%inside date.txt"
)
pause



2. can we keep the original file name to be applied ot the outside date and inside date files? This will be ideal if there are multiple files being handled at the sametime as we need to keep them separate.
I thought something like below might work but have not been able to incorporate it to test yet.

Code: Select all

I thought of using the %%~nxf so the output line would be 
findstr /lvg "%day1% %day2% %day3%" "%%i" >> "%filepath%%%~nxf_Outside date.txt" && echo "%%~nxf_Outside date.txt" has been created


foxidrive
Expert
Posts: 6031
Joined: 10 Feb 2012 02:20

Re: 2 questions

#10 Post by foxidrive » 29 Jul 2015 14:07

sfournier wrote:can we change the 3rd day to be 2359 instead of NOW?


I've pasted the changed code I wrote earlier for you to test - I don't think you noticed it
and if you want the year 2359 to be the 3rd day then that is implemented below.

It also uses the filenames you suggested and I put the pause in the place you asked for.

I noticed you used /lvg several times in the findstr switch and that is not required, but
test the following:

Code: Select all

@echo off
set "filepath=M:\Pharmacy\PACMED\test\"
set "ffile=%filepath%\meditech extracts\*.xo"

echo  >"%temp%\%~n0.vbs" s1=DateAdd("d",0,now)
echo >>"%temp%\%~n0.vbs" s2=DateAdd("d",1,now)
echo >>"%temp%\%~n0.vbs" s3=DateAdd("d",2,now)
echo >>"%temp%\%~n0.vbs" WScript.Echo "1 "^&year(s1)^& right(100+month(s1),2)^& right(100+day(s1),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "2 "^&year(s2)^& right(100+month(s2),2)^& right(100+day(s2),2)
echo >>"%temp%\%~n0.vbs" WScript.Echo "3 "^&year(s3)^& right(100+month(s3),2)^& right(100+day(s3),2)
for /f "tokens=1,2" %%a in ('cscript /nologo "%temp%\%~n0.vbs"') do set "day%%a=%%b"
del "%temp%\%~n0.vbs"
echo "%day1%" "%day2%" "%day3%"

set "day3=2359"

for %%i in ("%ffile%") do (

findstr /v "%day1% %day2% %day3%" "%%i" >nul || (
   type "%%i" >> "%filepath%%%~nxi_Outside date.txt"
   echo "%%~nxi_Outside date.txt" has been created
   pause
)

findstr /v "%day1% %day2% %day3%" "%%i" >nul && (
   type "%%i" >> "%filepath%%%~nxi_Inside date.txt"
)

)

sfournier
Posts: 43
Joined: 21 May 2013 12:38

Re: 2 questions

#11 Post by sfournier » 29 Jul 2015 14:35

I had tested that previously and it didn't seem to work. My apologies for not updating after your post prior.

The code posted in your last update creates the Inside date file correctly but was not generating the files. I changed the "||" to "&&" and this seems to have corrected the file generation issue.

And just for clarification, in regards to Day3. I'm using todays date as the example. This should be 20150731 but the time as @2359.
The previous code would pull out legitimate lines that should have been in the Inside date, but were move to Outside date.

The issue is that it does not seem to be extracting the data properly now. The inside and outside files are identical to the original.

foxidrive
Expert
Posts: 6031
Joined: 10 Feb 2012 02:20

Re: 2 questions

#12 Post by foxidrive » 29 Jul 2015 15:15

sfournier wrote:And just for clarification, in regards to Day3. I'm using todays date as the example. This should be 20150731 but the time as @2359.


That's changing the ball game, as time wasn't mentioned.

Having the task changed is something that really grinds after it happens for the 10,000 time.
No offense as you're a nice fellow - but batch files often change a great deal even on minor changes to the task, and it's like scratching your fingernails down a blackboard!

sfournier
Posts: 43
Joined: 21 May 2013 12:38

Re: 2 questions

#13 Post by sfournier » 29 Jul 2015 15:19

oh sorry i thought that was what the code was defining.
in this part of the code, I thought the "now" was defining the time as the time you are running it.
That was the way it was appearing to function.

Code: Select all

echo  >"%temp%\%~n0.vbs" s1=DateAdd("d",0,now)
echo >>"%temp%\%~n0.vbs" s2=DateAdd("d",1,now)
echo >>"%temp%\%~n0.vbs" s3=DateAdd("d",2,now)

Aacini
Expert
Posts: 1885
Joined: 06 Dec 2011 22:15
Location: México City, México
Contact:

Re: 2 questions

#14 Post by Aacini » 29 Jul 2015 17:29

@sfournier, I suggest you to carefully read this post.

Antonio

sfournier
Posts: 43
Joined: 21 May 2013 12:38

Re: 2 questions

#15 Post by sfournier » 29 Jul 2015 17:48

Hi Aacini and Foxidrive,
I do honestly apologize, it was not my intention to change the scope of the batch file.
I, my fault not yours, completely misunderstood how the DateAdd function was defining the time.
My assumption came from the testing of the batch file, as it was separating out data that had the time later than "now". When "now" was the time the batch was ran.

For example.
If I use the Original example from first post, copied below, the 20150728 date works, the 2100 is the time associated with that data.

Code: Select all

XXXXX,XXXXXXX                  MN-1E      MN1E-101-1     XXXXXXXXXX MNO        003300     20150728 2100         1 XXXXXXXXXX  MN-1E1    

In running the test, if I ran it right now (1642) any data that had the correct date but a time after 1642 was being put in the Outside date file.

This is where my assumption came from that we could change the definition of "now" and use "2359" for example.

In my testing this was not working so I was posing the question on here.

I have been coding in NPR and the syntax is specific to the program I'm using so the knowledge I have led me to the incorrect assumption.

With my assumption aside, if time is not a factor in the extraction of the lines, what could cause the lines of data that have the correct day "day3" to pulled out?
I guess that should have been my question all along and I hope this helps.

Again I apologize, this forum and especially you Foxidrive have been huge helps.

Post Reply