I get files daily from differnet vendors in ASCII format. The line breaks
are noted by the ~ST and the columns are denoted by *. Below is an example
of a few lines.

ISA*00* *00* *ZZ*DHLCIDI *ZZ*TRN200175
*100126*020
8*U*00400*000000142*1*P*~GS*IA*DHLCIDI*TRN200175* 20100126*0208*142*X*004010~ST*
110*1420001~B3**AUSD000000017**MX**20100125*27629* ***DHLC*20100125~B3A*DR*1~C3*U
SD**USD~ITD*05*3****20100209*15~N1*BT*DELL DMS*25*00797056329~N3*501 DELL
WAY~N4
*ROUND ROCK*TX*786820001*US~LX*1~N1*SH*DELL DMS*25*00797056329~N3*200 DELL
WAY B
LDG RR 5 RO~N4*ROUND ROCK*TX*786820001*US~PER*SH*DELL COMPUTER~N1*CN*DEL
TDC~N3*
TUN HUA S RD~N4*TAIPEI**99999*TW~PER*DC*S FANGI J
WEN~P1**20090716*011****1~R1*D
HLC*AIR*AUS*DHL*TPE~RMT*AW*003479667520*276.29~NTE *CUS*DUTIABLE
SHIPMENT~L5*1***
*PKG90~L0*1*39*LB*20*A1***1*PCS**L~SL1*CX***6329
/H1***PP**I~L1*1*269.55*VS*26
955****400****FRT CHRG AMT~L1*2*6.74*VS*674****405****FUEL
SURCHARGE~C3*USD*1.00
0*USD~L3*39*B***27629*******L~SE*29*1420001~ST*110 *1420002~B3**AUSD000000018**MX
**20100125*14857****DHLC*20100125~B3A*DR*1~C3*USD* *USD~ITD*05*3****20100209*15~N
1*BT*DELL DMS*25*00797056329~N3*501 DELL WAY~N4*ROUND
ROCK*TX*786820001*US~LX*1~
N1*SH*DELL DMS*25*00797056329~N3*501 DELL WAY*TX~N4*ROUND
ROCK**786820001*US~PER
*SH*HOLLY ARNOLD~N1*CN*MITAC COMPUTER~N3*1/F 97 HO YEUNG ST*NT~N4*TUEN
MUN*NT*99
999*HK~PER*DC*CHRISTINE
LEE~P1**20090720*011****1~R1*DHLC*AIR*AUS*DHL*HKG~ RMT*AW
*003480062401*148.57~NTE*CUS*DUTIABLE
SHIPMENT~L5*1****PKG90~L0*1*14*LB*3*A1***1


I need to make these into readable lines an columns rather quickly each
morning. I would like to use a macro to do this incase I am out others could
use this as well.

Thank you,
Holly