def checkChars(inputString):
outputString = ""
allowedChars = [" ", "/", ":", ".", ",",";"] # The characters you want to include
for l in inputString:
if l.isalnum() or l in allowedChars: # This line will check if the character is alphanumeric or is in your allowed character list
outputString += l
return outputString
根据这个{a1},我相信你可以做这样一个函数:
如果有帮助,请告诉我!干杯
我不知道如何在Excel中执行此操作,但是,您可以轻松地将Excel文件加载到“pandas.dataFrame”中,然后使用正则表达式忽略非ascii字符:
在这里,您可以找到关于loading an Excel file into a dataframe的额外解释 在这里你可以阅读关于more ways to ignore non-ascii chars in ^{}
相关问题 更多 >
编程相关推荐