Results 1 to 3 of 3

Splitting txt file into multiple txt files

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-28-2010
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    105

    Splitting txt file into multiple txt files

    Hello,

    I would like to create a macros that can split a txt file (opened as a tab delimited xls file like the attached ) into seperate txt files in the current directory. I would like each txt file to be named after its article #. I would like the break to come right after Journal-Code:

    i.e. so this would be named "1.txt"

    
                                   1 of 159 DOCUMENTS
    
    
    
                                      TendersInfo
    
                               January 6, 2010 Wednesday
    
    India : News Roundup: Novatium To Raise $10M Growth Fund
    
    BYLINE: datta03
    
    LENGTH: 410 words
    
    
    ***Novatium believes the fund will help it market its products internationally,
    besides reaching every corner of India.
    Dorf Ketal Buys DuPont Unit For $40M - Mumbai-based specialty chemicals company
    Dorf Ketal Chemicals has acquired the global specialty catalysts business of
    DuPont Chemicals and Fluoroproducts for around $40 million. The acquired unit....
    
    .............UMINOUS COAL UNDERGROUND MINING (53%); NAICS521110
    MONETARY AUTHORITIES - CENTRAL BANK (50%); SIC6011 FEDERAL RESERVE BANKS (50%)
    
    GEOGRAPHIC: MUMBAI, INDIA (91%) TAMIL NADU, INDIA (58%) INDIA (94%)
    
    LOAD-DATE: January 13, 2010
    
    LANGUAGE: ENGLISH
    
    PUBLICATION-TYPE: Web Publication
    
    JOURNAL-CODE: 81
    
    

    The following is the second txt file named "2":

                 Copyright 2010 TendersInfo - Euclid Infotech Pvt. Ltd.
                                  All Rights Reserved
                                 Provided by Al Bawaba
    
    
                                   2 of 159 DOCUMENTS
    
    
    
                                      TendersInfo
    
                                January 19, 2010 Tuesday
    
    United States : DuPont solar project to mean up to 80 new jobs in Circleville
    area
    
    BYLINE: deepak03
    
    LENGTH: 189 words
    
    
    ***DuPont will invest $175 million in its Pickaway County plant and hire up to
    80 new workers to build solar-power components in there, the company said today.
    
    .............................
    
    PERSON: TED STRICKLAND (92%); STEVE AUSTRIA (53%)
    
    GEOGRAPHIC: OHIO, USA (79%) UNITED STATES (92%)
    
    LOAD-DATE: January 20, 2010
    
    LANGUAGE: ENGLISH
    
    PUBLICATION-TYPE: Web Publication
    
    JOURNAL-CODE: 81
    and so on..
    The original aggregated txt file always starts with 1, and goes in sequential order to N, there are no omissions.
    Attached Files Attached Files
    Last edited by undergraduate; 05-02-2010 at 10:42 AM.

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