[NTLUG:Discuss] regexp/script

[Wrenn, Bobby J.]

I have some files (209 total) with customer address information. I need to
get the customer address into a comma delimited file with the file name
(minus extension) as the first field.

The file names have spaces in the name and a .txt extension
Each file has the address embedded like this:
============================
               Equipment Location
               __________________
Comments
 
_________
               Customer Name
               123 Somestreet
               Somecity                  ST  12345

===========================

The output file needs to look like:
===========================
name of file1,1st Customer Name,123 Somestreet,Somecity,ST,12345
name of file2,2nd Customer Name,234 Nextstreet,Nextcity,ST,23456
===========================

Is there an easy way to get the addresses out of the files? Because I am
trying to learn this, an explanation of the process would be helpful. If it
is more complicated than I anticipate, please contact me off list with your
price for the answer. I can expense a small fee.

TIA
Bobby Wrenn
Sr. Service Planner
BancTec, Inc.
972.450.7832