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.
Bookmarks