*English is not my native language, I translated some parts with CHATGPT, thank you.
My company has various types of PDF purchase orders. It’s large and complex data, and the layout is quite unorganized. However, I want to filter out product data from this information. Here is a sample of the data that I extracted into a .txt file (sorry, it’s in Thai). I’d like to extract only the data highlighted in yellow separate cells in Excel, but I’m unsure how to match it precisely to identify the products. In addition to the product list in the .txt file, there are also other details such as the company name and address.
ashokkarale
Anil_G
gorby
anjasing
adi.mehare
ppr
Speziman
Jon_Smith
Andreea_Nistor
Suzuki_N