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... |
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... |
All times are GMT +1. The time now is 09:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com