The command below is getting me the output I need.
awk -F"," ' {
if ($6 = 475) print "@@"$3 " " "0000" $10 "0" $1 "00000000" $8}' ${DIR1}${TMPFILE1} | sed -e 's/@@1//g' > ${DIR2}${TPRFILE}

Output:
900018732 00004961160200805160000000073719

Now I need to incorporate this sed command to reformat the date to mmddyy:
sed 's/^\(..\)\(..\)\(..\)\(..\)$/\3\4\2/'

Any ideas...

Like this?

Please provide sample data.

Thanks, that works, but what I really want to do is reformat the date in its current position, and leave all the text around it the same.

Is this possible, or am I confusing.

I was able to get it done, the long way. Yes, I know, it looks funny.

awk -F"," '{ if ($6 = 475) print $1 "," "@@"$3 "," $6 "," $10 "," $8}' ${DIR1}${INFILE} | sed -e 's/.*\(200.\{5\}\)00000000.*/\1/g' -e 's/^..\(..\)\(..\)\(..\)/\2\3\1/g' | sed -e 's/@@1//g' | sed -e 's/\.//g' | awk -F"," ' { print $2 " " "0000" $4 "0" $1 "00000000" $5}' > ${DIR2}${TPRFILE}