Convert Many Invoice Formats to a Standard Format

[joeny0706]

Paul

I have been using the file you created. It works good to get the task completed.
I had to make some changes to the raw data store names that is causing an issue. For many of the stores I have created a copy of the store with the word "STALE" after the name. They both are the same store.

So now it is not matching like I first asked you it needed to. Can you adjust your code so it ignores the word STALE when it is comparing store names. Stale will always be at the end of the store name.

I have attached a copy of the file you created for me.



So I need it to ignore STALE when it is matching up store names.

ex

PriceChopper:Pch215 Sidney

PriceChopper:Pch215 Sidney STALE

I hope that is an easy adjustment.

Thanks for the help.