I am in alignment with Dave on the restructure part! Looks like the Acct#Name(a
'descriptive' text string  for the Acct#) is being exported/concatinated with the
Acct# (numeric) field. You may not always have some say regarding the data file
received, but if you are providing a 'service' by crunching the data; there may
be leverage opportunity for defining the data input requirements from your
perspective. There is a higher marging of erroneous outputs as the incoming data
sets are so varied; your chance for 'catching' 100% of the 'exceptions' becomes
futile! Untill that has the option for bringing the issue(s) to the negotiating
table, we (you) are stuck with what you got!
...and then there is this team of peripheral grey matter to lean on.