[NTLUG:Discuss] YA script question.

[Bobby Wrenn]

A little background on what I am trying to accomplish.

I get address  lists from our sales people. Of course they come in all 
shapes and sizes. Mostly M$ spreadsheets.

Since the data comes from the customer it is seldom in a format I can 
run through my zone software. I would like to preserve as much of the 
original data as possible. With the help of this list I have cut my turn 
around time by over 50%.

Here is the latest wrinkle. I have a spreadsheet that looks like this:

123 street1
city1 st , 12345

321 street2, suite A
city1 st , 54321

Each record is two lines with a blank line seperating records. I need 
the two lines for each record combined into a single line and comma 
seperated. I also need to remove any embedded commas and remove the 
space before and after the comma in front of the zip code. Then just to 
make it enteresting and because my locator program requires it. I need 
to make the zip code the first field.

TIA
Bobby