pixelRONIN
Technical User
I'm in dire need of some assistance on parsing a txt file. I'm currently involved in redoing the website for a Community Supported Radio station here in Austin, TX.
The station's URL is: The new site that I'm developing is:
Login using:
user name = guest
password = password
The txt file I'm having the problem parsing is part of the play list area in the existing site:
This play list is generated by a software program called Music Librarian and is exported as a fixed-length txt file. Well, sort of. I think the txt file starts out as fixed-length then loses the fixed lengths. As you see below.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Play Report
PLAY DATE: Tue, 04/01/2003
12:00 AM PROGRAM 69086A LOT OF NIGHT MUSIC + 8888888
12:01 AM PROGRAM 74191From the Beethoven Satellite Network + 8888888
6:00 AM PROGRAM 72473CLASSICS FROM THE KMFA LIBRARY + 8888888
6:01 AM Leopold Mozart 1736Trumpet Concerto Erato 55014
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
I would like to clean out the header at the top of the page and parse out the 'PROGRAM' lines and to parse out the numbers prior to third field, ie 69086A LOT OF MUSIC, the 69086 needs to be taken out.
I would like to import this file into Access because I'm not very versed in VBScript, or any other scripting language for that matter. I'm a Graphic Artist learning Web skills to become more marketable - hence this pro-bono job.
I have attached the txt playlist file spewed out by Music Librarian, I have contact the Software vendors and got no help from them. Big surprise there!
Ideally, I need to write a parser that converts the present "whatever" delimited txt file into a comma separated file to import this file into Access.
This is a far as I have gotten in this process.
The program titles for the station are in a separate db, I would like to have the db create the table headers then VBScript parse in the songs associated to the program.
Is this too much to ask?
Let me know and I really appreciate any assistance you can give!
pR
The station's URL is: The new site that I'm developing is:
Login using:
user name = guest
password = password
The txt file I'm having the problem parsing is part of the play list area in the existing site:
This play list is generated by a software program called Music Librarian and is exported as a fixed-length txt file. Well, sort of. I think the txt file starts out as fixed-length then loses the fixed lengths. As you see below.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Play Report
PLAY DATE: Tue, 04/01/2003
12:00 AM PROGRAM 69086A LOT OF NIGHT MUSIC + 8888888
12:01 AM PROGRAM 74191From the Beethoven Satellite Network + 8888888
6:00 AM PROGRAM 72473CLASSICS FROM THE KMFA LIBRARY + 8888888
6:01 AM Leopold Mozart 1736Trumpet Concerto Erato 55014
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
I would like to clean out the header at the top of the page and parse out the 'PROGRAM' lines and to parse out the numbers prior to third field, ie 69086A LOT OF MUSIC, the 69086 needs to be taken out.
I would like to import this file into Access because I'm not very versed in VBScript, or any other scripting language for that matter. I'm a Graphic Artist learning Web skills to become more marketable - hence this pro-bono job.
I have attached the txt playlist file spewed out by Music Librarian, I have contact the Software vendors and got no help from them. Big surprise there!
Ideally, I need to write a parser that converts the present "whatever" delimited txt file into a comma separated file to import this file into Access.
This is a far as I have gotten in this process.
The program titles for the station are in a separate db, I would like to have the db create the table headers then VBScript parse in the songs associated to the program.
Is this too much to ask?
Let me know and I really appreciate any assistance you can give!
pR