About Arcite

Arcite · ‎03-30-2016

you might want to fix the typos in your question, it took me a few reads to realize "How does on add" was actually "How does one add", I'd edit for you but I guess I don't have high enough karma to do so

Arcite · ‎03-30-2016

Although its not the best answer, and I'm hoping someone else can come up with something better, I was able to use eval to create a new id number that included both, reworked the usb_ids.csv file to match this change and it work. ...| eval ID = tostring(vendor_id) + tostring(product_id) | table ID | lookup usb_ids.csv ID as ID OUTPUT description Another option would be to write a Python script to look it up sequentially and use an external lookup

Arcite · ‎03-29-2016

I have created a CSV from Linux's usb.ids (http://www.linux-usb.org/usb.ids ) that has vendor_id,product_id,VendorDesc,ProductDesc as the first line. I am trying to create a lookup that takes the Vendor Id and Product Id to fill in the Descriptions. When I do the search ... | lookup usb_ids.csv vendor_id AS vendor_id product_id AS product_id OUTPUT VendorDesc, ProductDesc it works for any value that is unique. For example, vendor_id=04e6 and product_id=5116 does not work; I'm assuming that this happens because vendor_id=0486 appears in both the vendor_id and product_id fields and 5116 matches a few product_ids for different Vendors. Is there a way for it to match BOTH the vendor_id and product_id to get the correct values?

Posts	3
Solutions	1
Karma Given	5
Karma Received	0
Member Since	‎03-29-2016

Online Status	Offline
Date Last Visited	‎06-05-2020 02:04 AM

How to make a sequential lookup?

Re: How does one add the needed python library on ...

Re: How to make a sequential lookup?

How to make a sequential lookup?