Splitting text files

[NickC111]

Good Afternoon

I have a text file that looks like this

05/12/0015LB
Standard Text
CONDITIONAL APPROVAL

08/12/0010
Raw Date
CONDITIONAL APPROVAL

52/12/0012LB
Max Data
CONDITIONAL APPROVAL

13/12/0005
Standard
REFUSAL

13/12/0007
Data Feed
CONDITIONAL APPROVAL

I want to be able to create mulitple text files by splitting the data by blank rows and rename the file as the number in the first line of each split

Example

Text called 05/12/0015LB

File contains
05/12/0015LB
Standard Text
CONDITIONAL APPROVAL

Anys ideas?

 

[PHV]

Have a look at FileSystemObject.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886