python清空text中的内容,从python中的字符串中删除text：u

I am using xlrd library to import values from excel file to python list.

I have a single column in excel file and extracting data row wise.

But the problem is the data i am getting in list is as

list = ["text:u'__string__'","text:u'__string__'",.....so on]

How can i remove this text:u from this to get natural list with strings ?

code here using python2.7

book = open_workbook("blabla.xlsx")

sheet = book.sheet_by_index(0)

documents = []

for row in range(1, 50): #start from 1, to leave out row 0

documents.append(sheet.cell(row, 0)) #extract from first col

data = [str(r) for r in documents]

print data

解决方案

Iterate over items and remove extra characters from each word:

s=[]

for x in list:

s.append(x[7:-1]) # Slice from index 7 till lastindex - 1