In most cases the data is:
Customer then Store Number, TTTTTTT #####
But in some cases the user enters the word "Store" between the company and the store number.
Others add the city after Store Number, and still others do not leave a space between the word store and the number, and finally the case I don't think simple logic will resolve, in some instances the users prepend the the store number with the country. Although, now that I think of it, I am pretty sure I can handle removing the country because that account uses a fairly standard format.
------------------------------
Paul Peterson
------------------------------
