Oct-25-2023, 06:14 PM
I'm trying to search for values from a list of values within a csv file. That CSV comes from the system which contains details about the machine that was read the values from. The machine has 2 parts, 1 which has the department name where the machine is located and another is the task that said machine does. Eg,
Machining & Robotics Dept., ID:C1878/23, ........other sensor reads
This information will be contained within the csv along with a ton of other reads from the sensors. I want to file these csv's with the machine part as the file name by matching the contents in the csv file with a central excel file that contains just the department names and the machine part ID, both of which must match to be filed under said part name.
How do I match the contents of the csv file to that of the excel file with a whole lot of other information that come in the csv file?
Machining & Robotics Dept., ID:C1878/23, ........other sensor reads
This information will be contained within the csv along with a ton of other reads from the sensors. I want to file these csv's with the machine part as the file name by matching the contents in the csv file with a central excel file that contains just the department names and the machine part ID, both of which must match to be filed under said part name.
How do I match the contents of the csv file to that of the excel file with a whole lot of other information that come in the csv file?