Python and BeautifulSoup4 - Extract Text from TD tags

Question

I am stuck after looking through many other questions. My code currently is breaking the data into named rows, but is returning the entire line instead of just the text included, I am just looking for ASCO VALVE MFG., INC. from the following line: I am not sure how to pull out just that text from the row.

****ASCO VALVE MFG., INC.****

My input looks like: Headers:

 
        WH
        OrderNo.
        Cust.
        Customer Name
        Item Number
        Item Description 1
        Item Description 2
        Qty
        S/N

Data rows are as below:


     09
     92427
     20668
     ASCO VALVE MFG., INC.
     EQPRAN77333
     RANPAK FILLPAK TT
     S/N 50742543
     1
     50742543

My code currently is breaking the data into named rows, but is returning the whole html line.

soup1 = BeautifulSoup(output, "html.parser")
find_string = soup1.body.find_all(text="-")
Customer_No = []
Serial_No = []
rows = soup1.find_all("tr")
title = rows[0]
headers = rows[1]
datarows = rows[2:]

for row in datarows :
    if len(row)> 7:
        WHID = row.contents[1]
        ORNO = row.contents[3]
        CSNO = row.contents[5]
        CSNM = row.contents[7]
        ITNO = row.contents[9]
        DESC = row.contents[11]
        DESC2 = row.contents[13]
        QTY = row.contents[15]
        SN = row.contents[17]
        print ITNO
    else:
        continue

What I am trying to end up with is a dictionary I guess of [text in CSNO] and [text in SN] pairs to match with a 2nd CSV file. I hope that all makes sense.

Python and BeautifulSoup4 - Extract Text from TD tags

Answers (1)

Related Questions