Emergency UNIX and Linux Support

 
BAT:0310:2009-08-0:Y4   :H:D:00003721:03103721.IFH:00138770:05767:00000000001279'
EXR:CLP:912.570000'
STA:A:9071559:2009-08-10::Wer::Mrs'
DEF::531.97:531.97:310221661617::+ABC:BAL:1:N::::5:40.00:0.00:2009-08-10:CN:1111111111109962::3:N:missc :N:PH:00010833:
0001+ABC:FPT:4:N::::5:19.99:0.00:2009-08-10:CN:1111 1111 1111 9621::3:N:miss c ross:N:AI:00220600:S3IA'
VDI:2004-03-12:133030431725:4:M:00001912:AT:BSP:9124029676:2004-05-06:Parker:4:12:::::I:::::N::129.00:129.00
:1234567887234567678:0:155.40::6:::::+TAX:UB:6.30+TAX:XT:15.10'
CTR:2009-08-10:0.00:0.00:30.00:30.00:7819.00:7819.00'
GTR:11.50:0.00:0.00:28457.81:149449.38:21298.48:154882.82:1725.89'
TRA'

awk -F'\+ABC' '{print$1}NF>1{for (i=2;i<=NF;i++)print $i}' OFS=':' |
awk -F: '{if ($27)print $27; else if ($12 ~ /^TXE$|^AF$|^XT$|^TT$|^IT$|^TX$|^DX$|^TY$|^DT$|^MO$|^SE$|^CF$|^AXE$|^DF$|^CX$|^TF$|^DE$|^XF$|^CNE$|^IX$|^CN$|^SC$|^XTE$|^AX$|^CX$/) print $13}' |
awk -F "" '{j=0; for(i=1;i<7+j;i++)if($i==" ")j++; for(;i<=(NF-4);i++)$i="*"}1' OFS=""

nawk '
($12 ~ /TXE|AF|XT|TT|IT|TX|DX|TY|DT|MO|SE|CF|AXE|DF|CX|TF|DE|XF|CNE|IX|CN|SC|XTE|AX|CX/)
{
m=match($13," ")
x=length($13)
             if (m) {
                         s=substr($13,1,7)
                         b=substr($13,x-3)
                        for (i=8;i<x-3;i++) {stars=stars"*"}
                     }
             else {
                          s=substr($13,1,6)
                          b=substr($13,x-3)
                          for (i=7;i<x-3;i++) { stars=stars"*" }
                    }
    $13= s stars b
}
1' FS=":" OFS=":" infile.txt > outfile.txt

then you can rename the output file:-
mv outfile.txt  infile.txt