Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data from large text files for beginner
Hi all,
I'm a beginner for Macro kind of thing. I need some help on extracting data from large text file. The text file look like these; C1111-1111,_M322209,step1,081022,095518,P C1111-1111,_M322209,step2,081022,095527,P C1111-1111,_M322209,step3,081022,095528,P C1111-1111,_M322209,step4,081022,095531,P C1111-1111,_M322209,step5,081022,095532,P C1111-1111,_M322209,step6,081022,095534,P C1111-1111,_M322209,step7,081022,095535,P C1111-1111,_M322209,step8,081022,095537,P C1111-1111,_M322209,step9,081022,095538,P C1111-1111,_M322209,step10,081022,095539,P C1111-1111,_M322209,step11,081022,095548,P C1111-1111,_M322209,step12,081022,095551,P C1111-1111,_M322209,step13,081022,095553,P C1111-1111,_M322209,step14,081022,095556,P C1111-1111,_M355509,final_step,081022,095736,P C2222-2222,_M355509,step1,081022,095518,P C2222-2222,_M355509,step2,081022,095527,P C2222-2222,_M355509,step3,081022,095528,P C2222-2222,_M355509,step4,081022,095531,P C2222-2222,_M355509,step5,081022,095532,P C2222-2222,_M355509,step6,081022,095534,P C2222-2222,_M355509,step7,081022,095535,P C2222-2222,_M355509,step8,081022,095537,P C2222-2222,_M355509,step9,081022,095538,P C2222-2222,_M355509,step10,081022,095539,P C2222-2222,_M355509,step11,081022,095548,P C2222-2222,_M355509,step12,081022,095551,P C2222-2222,_M355509,step13,081022,095553,P C2222-2222,_M355509,step14,081022,095556,P C2222-2222,_M355509,final_step,081022,095736,P This is only a complete steps of a test for 2 board. The text file could have hundred of lines. What I want is the last step for each board. These should do. C1111-1111,_M355509,final_step,081022,095736,P C2222-2222,_M355509,final_step,081022,095736,P Any help would be appreciate.Thanks... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data from large text files for beginner
B1, array formula entered, (confirmed with Ctrl+Alt +Enter ) :
{=INDEX(A:A,SMALL(IF(ISNUMBER(FIND("final_step",A$ 1:A$1000)),ROW(A$1:A$1000),60000),ROWS(A$1:A1)))&" "} Regards Bosco " wrote: Hi all, I'm a beginner for Macro kind of thing. I need some help on extracting data from large text file. The text file look like these; C1111-1111,_M322209,step1,081022,095518,P C1111-1111,_M322209,step2,081022,095527,P C1111-1111,_M322209,step3,081022,095528,P C1111-1111,_M322209,step4,081022,095531,P C1111-1111,_M322209,step5,081022,095532,P C1111-1111,_M322209,step6,081022,095534,P C1111-1111,_M322209,step7,081022,095535,P C1111-1111,_M322209,step8,081022,095537,P C1111-1111,_M322209,step9,081022,095538,P C1111-1111,_M322209,step10,081022,095539,P C1111-1111,_M322209,step11,081022,095548,P C1111-1111,_M322209,step12,081022,095551,P C1111-1111,_M322209,step13,081022,095553,P C1111-1111,_M322209,step14,081022,095556,P C1111-1111,_M355509,final_step,081022,095736,P C2222-2222,_M355509,step1,081022,095518,P C2222-2222,_M355509,step2,081022,095527,P C2222-2222,_M355509,step3,081022,095528,P C2222-2222,_M355509,step4,081022,095531,P C2222-2222,_M355509,step5,081022,095532,P C2222-2222,_M355509,step6,081022,095534,P C2222-2222,_M355509,step7,081022,095535,P C2222-2222,_M355509,step8,081022,095537,P C2222-2222,_M355509,step9,081022,095538,P C2222-2222,_M355509,step10,081022,095539,P C2222-2222,_M355509,step11,081022,095548,P C2222-2222,_M355509,step12,081022,095551,P C2222-2222,_M355509,step13,081022,095553,P C2222-2222,_M355509,step14,081022,095556,P C2222-2222,_M355509,final_step,081022,095736,P This is only a complete steps of a test for 2 board. The text file could have hundred of lines. What I want is the last step for each board. These should do. C1111-1111,_M355509,final_step,081022,095736,P C2222-2222,_M355509,final_step,081022,095736,P Any help would be appreciate.Thanks... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Large Text Files | Excel Discussion (Misc queries) | |||
Extracting data from large worksheet | Excel Worksheet Functions | |||
Text Import Wizard (use for large files) | Excel Discussion (Misc queries) | |||
Extracting data from multiple excel files. | Excel Discussion (Misc queries) | |||
Opening large text files | Excel Discussion (Misc queries) |