Looking up Specific Criteria in line item and doing a LookUP

[usama5788]

Can you please assist in helping with my Transaction memo line items below. Please also see ID name and ID number below. I want to be able to have some sort of formula that can look into my Transaction memo and pick up the Vendor ID and its Vendor Name. As you can see though that not all Memo transactions formatting is not the same. And I cannot find any consistency within each line item. The only thing that is consistent is that Vendor ID# contains 10 digits and also the word "AmericanExpress"

Can you please help since I have 100s of line items that are similar to this.

Please see attachment.