Creating a Macro, finding channel times

Hello,
I am new at creating macros on excel. I am trying to create a macro on excel to take data out of a file that one of my machines create. I work in the biotech field, and it is irrelevant and probably just complicate then actually help.
Basically I put a sample into the machine, and it spits out a trace file. This trace file has 100s of lines, and its the data of what the machine is doing.
But through this mess, there are a few places of data that I really need. For example, there will be a sequence that goes,
"2012-11-20 17:09:04> Microlab® STAR IVD : 1000µl Channel Dispense (Single Step) - complete; > channel 1: DWP_1600ProcessingUnit_Pipette_Home, A1, 73 uL > channel 2: DWP_1600ProcessingUnit_Pipette_Home, B1, 73 uL > channel 3: DWP_1600ProcessingUnit_Pipette_Home, C1, 73 uL > channel 4: DWP_1600ProcessingUnit_Pipette_Home, D1, 73 uL > channel 5: DWP_1600ProcessingUnit_Pipette_Home, E1, 73 uL > channel 6: DWP_1600ProcessingUnit_Pipette_Home, F1, 73 uL"

I need that time, 17:09:04 to be recorded, on an excel sheet. And this data is apart of the "VIC Addition", which is written much much before. I will show you the whole data now for the VIC addition. First it is aspirating, and then it is dispensing. This is how the whole sequence goes,
So I need it to record the name, "VIC Addition" and the time of dispense which is shown above.

Here is the whole sequence, there are many of these for different functions.

2012-11-20 17:08:52> USER : Trace - complete; ASPIRATE#############VIC_Addition#############
2012-11-20 17:08:52> AspirateErrorHandler : CheckAspirateResult() - start;
2012-11-20 17:08:52> AspirateErrorHandler : CheckAspirateResult() - progress; i_WellPattern=11111100 i_Type=1
2012-11-20 17:08:52> AspirateErrorHandler : CheckAspirateResult() - progress; in_WellPos=0 in_Positions=6
2012-11-20 17:08:52> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; ErrorFlag=0 BlockDataPackages=8
2012-11-20 17:08:53> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 1. BlockData: ChannelNumber=1 LabwareId=RGT_CAR_24_51 StepData=480.0 MainError=0 PositionId=2 RecoveryBtnId=0 SlaveError=0
2012-11-20 17:08:53> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 2. BlockData: ChannelNumber=2 LabwareId=RGT_CAR_24_51 StepData=480.0 MainError=0 PositionId=3 RecoveryBtnId=0 SlaveError=0
2012-11-20 17:08:53> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 3. BlockData: ChannelNumber=3 LabwareId=RGT_CAR_24_51 StepData=480.0 MainError=0 PositionId=4 RecoveryBtnId=0 SlaveError=0
2012-11-20 17:08:53> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 4. BlockData: ChannelNumber=4 LabwareId=RGT_CAR_24_51 StepData=480.0 MainError=0 PositionId=2 RecoveryBtnId=0 SlaveError=0
2012-11-20 17:08:53> Microlab® STAR IVD : Firmware Command (Single Step) - start;
2012-11-20 17:08:53> Microlab® STAR IVD : Firmware Command (Single Step) - complete; > RF: er00/00rf7.1S 2010-08-03
2012-11-20 17:08:53> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 5. BlockData: ChannelNumber=5 LabwareId=RGT_CAR_24_51 StepData=480.0 MainError=0 PositionId=3 RecoveryBtnId=0 SlaveError=0
2012-11-20 17:08:53> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 6. BlockData: ChannelNumber=6 LabwareId=RGT_CAR_24_51 StepData=480.0 MainError=0 PositionId=4 RecoveryBtnId=0 SlaveError=0
2012-11-20 17:08:53> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 7. BlockData: ChannelNumber=7 LabwareId= StepData= MainError=0 PositionId= RecoveryBtnId=0 SlaveError=0
2012-11-20 17:08:53> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 8. BlockData: ChannelNumber=8 LabwareId= StepData= MainError=0 PositionId= RecoveryBtnId=0 SlaveError=0
2012-11-20 17:08:53> AspirateErrorHandler : CheckAspirateResult() - progress; tmp_ChannelsCount=8
2012-11-20 17:08:53> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=1 tmp_ChannelUsed=1
2012-11-20 17:08:53> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-11-20 17:08:53> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_CAR_24_51 inVolume=480.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-11-20 17:08:53> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=2 tmp_ChannelUsed=1
2012-11-20 17:08:53> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-11-20 17:08:53> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_CAR_24_51 inVolume=480.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-11-20 17:08:53> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=3 tmp_ChannelUsed=1
2012-11-20 17:08:53> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-11-20 17:08:53> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_CAR_24_51 inVolume=480.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-11-20 17:08:53> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=4 tmp_ChannelUsed=1
2012-11-20 17:08:53> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-11-20 17:08:53> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_CAR_24_51 inVolume=480.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-11-20 17:08:53> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=5 tmp_ChannelUsed=1
2012-11-20 17:08:53> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-11-20 17:08:53> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_CAR_24_51 inVolume=480.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-11-20 17:08:53> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=6 tmp_ChannelUsed=1
2012-11-20 17:08:53> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-11-20 17:08:53> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_CAR_24_51 inVolume=480.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-11-20 17:08:54> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=7 tmp_ChannelUsed=0
2012-11-20 17:08:54> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=8 tmp_ChannelUsed=0
2012-11-20 17:08:54> AspirateErrorHandler : CheckAspirateResult() - complete; return=0
2012-11-20 17:08:54> TipPattern_Calculations : Map_ChannelNumber_To_ChannelPattern() - progress; o_ChannelPattern=11111100
2012-11-20 17:08:54> Dispense : Dispense() - start;
2012-11-20 17:08:54> Dispense : Dispense() - progress; in_Stage=48 in_ChannelPattern=11111100
2012-11-20 17:08:54> Dispense : SequenceState() - progress; io_TargetSequence Total=32 Count=32 CurPos=1 Max=6 UsedPositions=0 Name=Destination
2012-11-20 17:08:54> Dispense : Dispense() - progress; StageDescription: VIC_Addition
2012-11-20 17:08:54> Dispense : Dispense() - progress; SequenceCounting: 1
2012-11-20 17:08:54> Dispense : Dispense() - progress; ChannelUse: 2
2012-11-20 17:08:54> Dispense : Dispense() - progress; Volume: 73
2012-11-20 17:08:54> Dispense : Dispense() - progress; LiquidFollowing: 0
2012-11-20 17:08:54> Dispense : Dispense() - progress; DispenseMode: 2
2012-11-20 17:08:54> Dispense : Dispense() - progress; FixedHeight: 2
2012-11-20 17:08:54> Dispense : Dispense() - progress; cLLD: 0
2012-11-20 17:08:54> Dispense : Dispense() - progress; SubmergeDepth: 0
2012-11-20 17:08:54> Dispense : Dispense() - progress; LiquidClass: MTS_Viro_IC_SurfacePartVolume
2012-11-20 17:08:54> Dispense : Dispense() - progress; MixCycles: 0
2012-11-20 17:08:54> Dispense : Dispense() - progress; MixPosition: 0
2012-11-20 17:08:54> Dispense : Dispense() - progress; MixVolume: 0
2012-11-20 17:08:54> Dispense : Dispense() - progress; SideTouch: 0
2012-11-20 17:08:54> Dispense : Dispense() - progress; TouchOff: 0
2012-11-20 17:08:54> Dispense : Dispense() - progress; AboveTouchOff: 0
2012-11-20 17:08:54> Dispense : Dispense() - progress; ZMove: 0
2012-11-20 17:08:54> Microlab® STAR IVD : 1000µl Channel Dispense (Single Step) - start;
2012-11-20 17:08:56> Microlab® STAR IVD : Firmware Command (Single Step) - start;
2012-11-20 17:08:56> Microlab® STAR IVD : Firmware Command (Single Step) - complete; > RF: er00/00rf7.1S 2010-08-03
2012-11-20 17:08:59> Microlab® STAR IVD : Firmware Command (Single Step) - start;
2012-11-20 17:08:59> Microlab® STAR IVD : Firmware Command (Single Step) - complete; > RF: er00/00rf7.1S 2010-08-03
2012-11-20 17:09:02> Microlab® STAR IVD : Firmware Command (Single Step) - start;
2012-11-20 17:09:02> Microlab® STAR IVD : Firmware Command (Single Step) - complete; > RF: er00/00rf7.1S 2010-08-03
2012-11-20 17:09:04> Microlab® STAR IVD : 1000µl Channel Dispense (Single Step) - complete; > channel 1: DWP_1600ProcessingUnit_Pipette_Home, A1, 73 uL > channel 2: DWP_1600ProcessingUnit_Pipette_Home, B1, 73 uL > channel 3: DWP_1600ProcessingUnit_Pipette_Home, C1, 73 uL > channel 4: DWP_1600ProcessingUnit_Pipette_Home, D1, 73 uL > channel 5: DWP_1600ProcessingUnit_Pipette_Home, E1, 73 uL > channel 6: DWP_1600ProcessingUnit_Pipette_Home, F1, 73 uL

Please upload a sample desired output excel worksheet.

Ok Cool, how do I upload the desired excel sheet. I like the upload the complete data sheet as well.

Ok cool. Let me try to explain what I need. Its prOutput.xlsxetty simple I think, but the data sheet might make it complicated. Heres the output file, just an example a short part of it. So there is a process by which our system works. This is the first column, its a process of steps its going through. Such as Pipette MGPs, Pipette Lysis, etc. On the data file however, those steps are labeled by the next column, such as MGP_DWP_Addition. So Pipette MGPs is MGP_DWP_Addition.
So what happens is that it does 4 sets 8 pipettes labled (A-H). So that A1-H1, is the 1st of the 4 sets A-H which is the 1-8 pipettes. What I want, is the aspiration dispense for each of the different colums. I will give an example of the file that comes out of the machine.

I am going to have my example on the next post.


So as you can see, there is MGP_DSWP_addition for dispense and aspiration. I want the aspiration time, which would be at here:
2012-12-14 10:33:05> USER : Trace - complete; ASPIRATE#############MGP_DWP_Addition#############
The time here is what I want for aspiration of MGP_DWP_addition

for the dissension I would want the same but for dispense,
2012-12-14 10:33:05> USER : Trace - complete; DISPENSE#############MGP_DWP_Addition#############

This goes through all the stages. I was wondering if I could write a macro to get this information. Thanks!

2012-12-14 10:33:05> USER : Trace - complete; ASPIRATE#############MGP_DWP_Addition#############
2012-12-14 10:33:05> AspirateErrorHandler : CheckAspirateResult() - start;
2012-12-14 10:33:05> AspirateErrorHandler : CheckAspirateResult() - progress; i_WellPattern=11111111 i_Type=1
2012-12-14 10:33:05> AspirateErrorHandler : CheckAspirateResult() - progress; in_WellPos=1 in_Positions=8
2012-12-14 10:33:05> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; ErrorFlag=0 BlockDataPackages=8
2012-12-14 10:33:05> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 1. BlockData: ChannelNumber=1 LabwareId=RGT_TROUGH_50_v004_0002 StepData=110.0 MainError=0 PositionId=1 RecoveryBtnId=0 SlaveError=0
2012-12-14 10:33:05> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 2. BlockData: ChannelNumber=2 LabwareId=RGT_TROUGH_50_v004_0002 StepData=110.0 MainError=0 PositionId=2 RecoveryBtnId=0 SlaveError=0
2012-12-14 10:33:05> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 3. BlockData: ChannelNumber=3 LabwareId=RGT_TROUGH_50_v004_0002 StepData=110.0 MainError=0 PositionId=3 RecoveryBtnId=0 SlaveError=0
2012-12-14 10:33:05> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 4. BlockData: ChannelNumber=4 LabwareId=RGT_TROUGH_50_v004_0002 StepData=110.0 MainError=0 PositionId=4 RecoveryBtnId=0 SlaveError=0
2012-12-14 10:33:05> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 5. BlockData: ChannelNumber=5 LabwareId=RGT_TROUGH_50_v004_0002 StepData=110.0 MainError=0 PositionId=5 RecoveryBtnId=0 SlaveError=0
2012-12-14 10:33:05> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 6. BlockData: ChannelNumber=6 LabwareId=RGT_TROUGH_50_v004_0002 StepData=110.0 MainError=0 PositionId=6 RecoveryBtnId=0 SlaveError=0
2012-12-14 10:33:05> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 7. BlockData: ChannelNumber=7 LabwareId=RGT_TROUGH_50_v004_0002 StepData=110.0 MainError=0 PositionId=7 RecoveryBtnId=0 SlaveError=0
2012-12-14 10:33:05> AnalyzeStepReturnStrings : Pipette_StepReturn_StringAnalysis - progress; 8. BlockData: ChannelNumber=8 LabwareId=RGT_TROUGH_50_v004_0002 StepData=110.0 MainError=0 PositionId=8 RecoveryBtnId=0 SlaveError=0
2012-12-14 10:33:05> AspirateErrorHandler : CheckAspirateResult() - progress; tmp_ChannelsCount=8
2012-12-14 10:33:05> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=1 tmp_ChannelUsed=1
2012-12-14 10:33:05> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-12-14 10:33:05> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_TROUGH_50_v004_0002 inVolume=110.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-12-14 10:33:05> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=2 tmp_ChannelUsed=1
2012-12-14 10:33:05> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-12-14 10:33:05> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_TROUGH_50_v004_0002 inVolume=110.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-12-14 10:33:05> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=3 tmp_ChannelUsed=1
2012-12-14 10:33:05> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-12-14 10:33:05> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_TROUGH_50_v004_0002 inVolume=110.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-12-14 10:33:05> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=4 tmp_ChannelUsed=1
2012-12-14 10:33:05> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-12-14 10:33:05> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_TROUGH_50_v004_0002 inVolume=110.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-12-14 10:33:05> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=5 tmp_ChannelUsed=1
2012-12-14 10:33:05> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-12-14 10:33:05> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_TROUGH_50_v004_0002 inVolume=110.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-12-14 10:33:05> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=6 tmp_ChannelUsed=1
2012-12-14 10:33:05> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-12-14 10:33:05> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_TROUGH_50_v004_0002 inVolume=110.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-12-14 10:33:05> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=7 tmp_ChannelUsed=1
2012-12-14 10:33:05> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-12-14 10:33:05> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_TROUGH_50_v004_0002 inVolume=110.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-12-14 10:33:05> AspirateErrorHandler : CheckAspirateResult() - progress; Handle tmp_ChannelNumber=8 tmp_ChannelUsed=1
2012-12-14 10:33:05> Pipetting_Constants : Get_Asp_PipState() - progress; inMainError=0 inSlaveError=0 inRecoveryBtnId=0 outPipettingState=1 (PIPETTING_OK)
2012-12-14 10:33:05> AspirateErrorHandler : GetPipettingState() - progress; inLabwareId=RGT_TROUGH_50_v004_0002 inVolume=110.0 inPipState=1 outPipState=1 PIPETTING_OK
2012-12-14 10:33:05> AspirateErrorHandler : CheckAspirateResult() - complete; return=0
2012-12-14 10:33:06> Dispense : Dispense() - start;
2012-12-14 10:33:06> Dispense : Dispense() - progress; in_Stage=14 in_ChannelPattern=11111111
2012-12-14 10:33:06> Dispense : SequenceState() - progress; io_TargetSequence Total=96 Count=32 CurPos=1 Max=8 UsedPositions=0 Name=MTS_SEQ_DWP_HOME_ALL_WELLS_PIPETTE
2012-12-14 10:33:06> Dispense : Dispense() - progress; StageDescription: MGP_DWP_Addition
2012-12-14 10:33:06> Dispense : Dispense() - progress; SequenceCounting: 1
2012-12-14 10:33:06> Dispense : Dispense() - progress; ChannelUse: 2
2012-12-14 10:33:06> Dispense : Dispense() - progress; Volume: 110
2012-12-14 10:33:06> Dispense : Dispense() - progress; LiquidFollowing: 1

No, I just need the time correspond to one of those values on the excel sheet. Do you need more explanation?

Basically I want this macro on excel, to take the items that I am looking for, for example on the excel file that I submitted, and then look at the text files and take the corresponding times for those events on the text file. Is that possible? If you need more clarification just let me know. Thanks.

Hi -


Please upload a complete sample of text file.

event

Okay I think I added them. One is an output file generated. It usually comes as a notepad text file but I copied pasted it in to excel. Second, is a macro my colleague worked on. He made it differently. It uses the same output file. Maybe you can take a look at both and see what you think can help me. Sorry

Hi -

You can try this;

Please Login or Register  to view this content.

event

Thank you but what I want is the aspirate dispense times for those those items I gave you in the first attachment. Like mgs and elution buffer. Does that make sense?

Hi -

Confusing, this is what you have wrote;

So as you can see, there is MGP_DSWP_addition for dispense and aspiration. I want the aspiration time, which would be at here:
2012-12-14 10:33:05> USER : Trace - complete; ASPIRATE#############MGP_DWP_Addition#############
The time here is what I want for aspiration of MGP_DWP_addition

for the dissension I would want the same but for dispense,
2012-12-14 10:33:05> USER : Trace - complete; DISPENSE#############MGP_DWP_Addition#############

This goes through all the stages. I was wondering if I could write a macro to get this information. Thanks!

in your post#12 file, please mark what lines are you trying to get.

event

Sure, let me try to explain it better. What I am trying to get is these cateogories,
"MGP_DWP_Addition, Lysis_Binding_Removal, Lysis_Binding_Removal_2, Wash_Addition, Wash_Removal, Wash_Addition_2, Wash_Removal_2, Elution_Addition_HCVGT."

So these are the categories I am looking for times for. The two times I am looking for are Aspirate and Dispense. And there are 4 asp/dsp times for each round A1-H1 (round 1) to A4-H4 (round 4).

I would like it to be organized in the output file I have provided earlier. Thanks.

YES! So those are the times we need, and then I would need the times for all the other ones that I had listed. Such as,
ASPIRATE#############Lysis_Binding_Removal############# , etc.
I just need all the aspirate and dispense times for all of the different categories that I gave on the output file or on the post before.
But yes, that is what I need.

Hi -

This is all you need.
1. make a copy of your text file in your pc
2. Open the excel file, enable macro and click on the button and it will ask you to locate the text file, select the text file and you're done.

event

Are you saying, I need to get the data imported into Excel. And then once it is imported into excel, I will have the data find the times I am looking for and paste it into the corresponding page, lets say that will be sheet 1. Then on sheet 2 of this document, I will have the times put in the order of the times I was looking for, to resemble what I posting before on the output file. Another question, can I have the times be pasted in the output excel sheet I made on output?

To start, I need to have a macro that gets the data. What is the button that you made? Is it anything, it says get data, but I try to open the data file and it says syntax error. How do I create a macro to fetch the data, and then change the data to have all the times in one column and all of the other information in another. I think once I reach that point, the macro will be pretty simple.

Thanks.

Hi -

You did not understand me.
you don't need to paste the input data into excel. my script will get the data directly from text file.
copy your input data and paste it into text file then run my code.

event

Hi -
Let me try to understand. You want me to copy the input data and paste it into the text file? Like a word file. Because it comes in a text file.
What does your code do?

Hi -

just follow my instructions.
if you already have the text file data, just open my excel file and click the button, a new window will appear, locate the text file and double click it. that's it.

event

Thank you for your help Event21. It was really great that you were able to take time and help me out. I have some other questions and I will need to do some more work this weekend and then I will let you know. Thanks again.

Test2.xlsmTest2.xlsmHello again,
Here is the scrip that Event21 developed. I do not understand the script completely because I would like to add a few functions to it that I find not possible to do. This is what I want to add to the script to find:

1) with mixed batch, more stages will be included. Please see attached an example of a mixed batch trace file.
2) add time for Eluate_Addition (HxV and HCVGT)
3) need to know the durations of each column for –

• QS dispense to Control dispense (HxV only)
• QS dispense to specimen dispense (HxV only)
• Control dispense to MGP dispense
• Specimen dispense to MGP dispense
• MGP dispense to Lysis addition dispense
• Lysis addition dispense to Lysis_Binding_Mix
• Lysis addition dispense to Lysis_Binding_Removal_2, aspirate
• Wash_addition dispense to Wash_removal aspirate
• Wash_addition_2 dispense to Wash_remova_2 aspirate
• Elution_Addition_HxV dispense to Eluate_Addition_HxV aspirate
• Elution_Addition_HCVGT dipsense (only the first set) to Eluat_Addition_HCVGT aspirate (the very first well)


I was wondering how on the script to add these. If you could help with this that would be great. Thanks!
I cant find on the script where it looks for a a particular phrase. I need to find that because i can add another one to find the other cateogories.
Time durations mean :Dispense - Aspirate

If you have any other questions please ask me. Thank you.