How to create a text file for Selenium Python to read with out extra character problems?



  • I'm able to make the xpath find work in all ways except reading in customers from a text file. I'm 98% sure it's a hidden character problem in the text file. What's the easiest way to take a column of names in an Excel file and save it as a file that can be read with this bit of code?

    customerlist = open("customerlist.txt", "r")
    
    customers = customerlist.readlines()
    
    for customer in customers:
       
       datarow = driver.find_element_by_xpath("//span[contains(text(),'"+customer+"')]")
    


  • Inserting this as the first item in the for loop did the trick

    customer = customer.rstrip("\n")
    


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2