How do I use a Lexicon as a Lookup Reference - Grooper 2.70.21

tmartin

My ultimate goal is to read a Vendor name from an invoice, then use that Vendor name as a reference to a lexicon that contains the Vendors' "Remit To" addresses. I have a Vendor Extractor that is extracting the Vendor Names correctly and I have a Lexicon that contains the Vendor Names and their addresses in the format: [VendorName]=[Address]

When I test the extraction, only the first address on the list is returned, regardless of the Vendor Name result.
Contents of my Lexicon:

Spartan Manufacturing=12 West Laguna Dr Irvine, Ca, 92612

Standard Products=19658 South Frisk Oklahoma City, OK 73102

Enid Parts=586 West Industrial Road Enid, OK 73703

Express=12333 N Dallas Tollway Dallas, Tx, 75032

Ingram Micro=P.O. Box 90341 Chicago, IL 60696-0341

Business Imaging Systems, Inc=PO Box 20007 Oklahoma City, OK 73156

Carahsoft Technology Corp=1860 Michael Faraday Drive, Suite 100 Reston, VA 20190

Rimage=NW5255 PO Box 1450 Minneapolis, MN 55485-5255

Newwave=4635 Wedgewood BLVD STE 107 Frederick, MD 21703-3300

Cranel=7564 Reliable Parkway Chicago, IL 60686

Triton Datacom=Addvantage Triton, LLC Dept 1044

P-S-S-Companies=1010 Lama STE. 710 Houston, TX 77002

Cook=22988 Network Place Chicago, IL 60673-1229

Grainger=DEPT. 80+446043 Palatine, IL 60038-0001

EMC=4246 Collections Center Drive Chicago, IL 60693

I get "12 West Laguna Dr Irvine, Ca, 92612" returned regardless of the Vendor Name. Is something set up wrong or am I off base with how I set this up? Please let me know if more information is needed. 

rmccutcheon

Okay so I figured mine out. On my Address field I have value type set to Internal. For my pattern I used [^\t\f:]+ under lookup options I set the included lexicon, and set enable translation to true. When I test on Enid Parts and Express I am getting the correct results.

RandoCalrisian

To help illustrate what @rmccutcheon has done I've added a screen shot and attached zip file with Grooper objects compatible with Grooper 2.70.