如何从txt文件中删除所有字母、空格和空行并写入excel

Question

我有一个类似的文件

cat
123-1
2311 

我希望它是这样的，没有前导或尾随空格或空线

123-1
2311

with open(r"C:Usersmiketest.txt", 'r', encoding="utf8") as f:
readline= f.readlines()

#clearUnwantedCharacters= ''.join(filter(clearlist.__contains__,readline))
#readline= ''.join(filter(clearlist.__contains__,readline))

readline =[line.replace(' ', '') for line in readline]
#readline =[line.replace('n', '') for line in readline]
#######
lines= readline.split("n")
no_empty_string= [line for line in lines if line.strip() !=" "]
'''
since list cannot be split, split individual items on the list  and append 
'''
readline =""
for line in no_empty_string:
readline += line + "n"

######
#test= readline
#remove unwanted characters with regex 
# readline= re.sub('[^0-9]',' ', str(readline))
# readline.strip(' ')
print(readline)
with open(r"C:Usersmiketest.txt", 'w', encoding="utf8") as f:
f.writelines(readline)

但我没有得到想要的结果(即无法清除空白和字母列表(

--用更多信息更新问题，我想把文本写到excel中，所以用逗号分隔的行代替换行符将是理想的

Answer 1

# Opening both files, iterating over the lines using .strip()
# and saving only lines that are not empty.
with open('test.txt', "r") as original, open("new_file.txt", "w") as new_file:
for line in original:
sline = line.strip()
if line not in ('', 'n'):
new_file.write(sline + "n")

$ cat new_file.txt 
123-1
2311