+ Reply to Thread
Results 1 to 3 of 3

Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders

Hybrid View

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    51

    Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders

    I want to run a macro, which will import Text (Required or All) from Many Text Files (.txt). Each Sub Folder in Directory has a Text File, which all are needed to be parsed to a common format.

    On an average I generate 40 to 50 Text Files a Day and then open each one of them and copy to excel manually then processing the data manually, which is taking much of my time.

    Text file has a data like

       SRR_NO   |SRR_STAT|      GEN_STR       
    ------------|--------|--------------------
        13765.06 CLO      71                  
    
    
    ELT_NAME:
    SDDR_3_4_3_4_RIGFLT_CSOL.DOC                                                    
    
    
       SRR_NO   |SRR_STAT|      GEN_STR       
    ------------|--------|--------------------
        12733.01 CLO      36                  
    
    
    ELT_NAME:
    SDDR_3_4_59_HSTA_POST_BRAKE.DOC
    Which I process manually like this
    Sn	File Name	ELT_NAME:	SRR_NO	SRR_STAT	GEN_STR
    1	PROJ_MAINTENANCE_O	SDDR_3_4_3_4_RIGFLT_CSOL.DOC	13765.06	CLO	71
    2	PROJ_MAINTENANCE_O	SDDR_3_4_59_HSTA_POST_BRAKE.DOC	12733.01	CLO	36
    3	PROJ2_PRIMARY_O	SDDR_1_5_7_9_CSOL.DOC	98765.06	SEC	14
    4	PROJ2_PRIMARY_O	SDDR_8_9_09_A_T_BKE.DOC	98763.01	CLO	67
    5	PROJ2C_CORE_O	SDDR_8_1_4_1_FLT_CL.DOC	90765.06	VER	45
    6	PROJ2C_CORE_O	SDDR_6_3_23_2_TA_PT_BR.DOC	9733.01	VER	87
    Is there any way to do this through macro... Need your help in automating the parsing process. Attaching sample files (text file & manually processed file) for your reference...
    Please help...

    Thank you
    Sample_File_Processed_(Done_Manually).xls
    Sample_Text_File_PROJ_MAINTENANCE_O.txt
    Last edited by Novice_To_Excel; 10-01-2012 at 11:11 AM.

  2. #2
    Registered User
    Join Date
    09-21-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders

    If not possible to do entire process in one go.

    I'm wondering Can we import Each Text File to Single Cell?
    Entire text should be on Single Cell, No matter how many lines of text might be there in text file. and corresponding cell should have Text File Name (to cross verify at any point of time)

    Is this possible? Please reply even if it is impossible!!

  3. #3
    Registered User
    Join Date
    09-21-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders

    No Response I think it is Not Possible...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1