Thank you for the help thus far. Perl is probably my best choice for this solution, but now for the added confusion. Like I said the format was very unorthodox.
The original format is:
http://web.njit.edu/~tmp8/testorig.txt
The desired format is:
Quote:
LAST,FIRST,132135,ADDRESS 1,ADDRESS 2 OR APPT,CITY,NJ,07444
LAST,FIRST,006273,ADDRESS 1,,CITY,NJ,08022
|
As you can see, the file is not organized easily, and if there is nothing provided for some fields to just leave them blank. Any help is greatly appreciated again. Thank you.
Tom