我试图对从Excel文档中获取的文本进行编码。它包含各种奇怪的字符,如引号、反斜杠、括号等。如何正确地将其转换为Python兼容的字符串,以便我可以处理它并将其写入变量?
ExampleText = "MINIMUM TRACK FASTENING SHALL BE 0.145" DIAMETER POWDER ACTUATED FASTENERS (P.A.F.S) SPACED ON 8" CENTERS FOR BEARING WALLS, AND AT 12" O.C. FOR NON-LOAD BEARING WALLS (U.N.O.), WITH 1 1/2" MINIMUM PENETRATION INTO CONCRETE. AT X-BRACED SHEAR WALLS, TRACK SHALL BE ATTACHED PER DETAILS. At Infinity Shear Panels (ISP’S) attach to slab w/ 0.145" x 1 1/2” powder actuated fasteners spaced on 4” centers (HILTI DS 37 P10 or equal) -OR- (6) 3/8" DIA. 2205 expansion anchors w/ 2 1/2" min. embedment - OR-Simpson "Titen" screws @ 6" o.c."我试过:str(ExampleText),但显然失败了。
谢谢你的帮助!
ps。下面是我得到的错误: UnicodeEncodeError:(“未知”,'\x00',0,1,'') ps2。我在铁笔下2.7我知道一个令人沮丧的人:
发布于 2015-03-13 01:25:52
您可以使用来自escape()包的re函数:
>>> import re
>>> re.escape(ExampleText)
'\\"MINIMUM\\ TRACK\\ FASTENING\\ SHALL\\ BE\\ 0.145\\"\\ DIAMETER ...'
>>> ExampleText = ExampleText.decode('string_escape')
'"MINIMUM TRACK FASTENING SHALL BE 0.145" DIAMETER ...'escape()函数将使用它们的双反斜杠等效符来转义所有非字母数字字符.这应该可以很好地处理输入字符串。
发布于 2015-03-13 01:22:39
如果给定的代码与您所拥有的完全匹配,那么就难怪它会出现问题。你用双引号包围它,但是字符串包含双引号。如前所述,当解释器看到下一个双引号时,字符串将结束,然后会出现一些它无法识别的术语(如DIAMETER和POWDER),然后最终将开始另一个字符串,依此类推。
您需要用反斜杠转义字符串的双引号,或者用两边的三个引号将字符串括起来。
ExampleText = "MINIMUM TRACK FASTENING SHALL BE 0.145\" DIAMETER POWDER ACTUATED FASTENERS (P.A.F.S) SPACED ON 8\" CENTERS FOR BEARING WALLS, AND AT 12\" O.C. FOR NON-LOAD BEARING WALLS (U.N.O.), WITH 1 1/2\" MINIMUM PENETRATION INTO CONCRETE. AT X-BRACED SHEAR WALLS, TRACK SHALL BE ATTACHED PER DETAILS. At Infinity Shear Panels (ISP’S) attach to slab w/ 0.145\" x 1 1/2\" powder actuated fasteners spaced on 4\" centers (HILTI DS 37 P10 or equal) -OR- (6) 3/8\" DIA. 2205 expansion anchors w/ 2 1/2\" min. embedment - OR-Simpson \"Titen\" screws @ 6\" o.c."或
ExampleText = """MINIMUM TRACK FASTENING SHALL BE 0.145" DIAMETER POWDER ACTUATED FASTENERS (P.A.F.S) SPACED ON 8" CENTERS FOR BEARING WALLS, AND AT 12" O.C. FOR NON-LOAD BEARING WALLS (U.N.O.), WITH 1 1/2" MINIMUM PENETRATION INTO CONCRETE. AT X-BRACED SHEAR WALLS, TRACK SHALL BE ATTACHED PER DETAILS. At Infinity Shear Panels (ISP’S) attach to slab w/ 0.145" x 1 1/2” powder actuated fasteners spaced on 4” centers (HILTI DS 37 P10 or equal) -OR- (6) 3/8" DIA. 2205 expansion anchors w/ 2 1/2" min. embedment - OR-Simpson "Titen" screws @ 6" o.c."""因此,内置语法突出显示您的示例由多个字符串组成,而我的示例是一个连续字符串。
此外,字符串只包含正斜杠,没有反斜杠,所以没有问题。如果存在反斜杠,并且希望解决这个问题,则在字符串前面加上一个r,以表示原始字符串:r'hello\nworld打印为hello\nworld。原始字符串唯一不能处理的是字符串中的最后一个字符是反斜杠。解决这个问题的方法是在之后添加:r'C:\Users\jsmith' + '\\'或r'C:\Users\jsmith' '\\' (在连接文字字符串时,+并不是绝对必要的)。
只有在将字符串写入源代码的情况下,这才是必要的。来自外部源(如input()或文件)的字符串将自动处理。
发布于 2015-03-13 01:18:53
从我们在评论中的谈话
# -*- coding: utf-8 -*-
ExampleText = '"MINIMUM TRACK FASTENING SHALL BE 0.145" DIAMETER POWDER ACTUATED FASTENERS (P.A.F.S) SPACED ON 8" CENTERS FOR BEARING WALLS, AND AT 12" O.C. FOR NON-LOAD BEARING WALLS (U.N.O.), WITH 1 1/2" MINIMUM PENETRATION INTO CONCRETE. AT X-BRACED SHEAR WALLS, TRACK SHALL BE ATTACHED PER DETAILS. At Infinity Shear Panels (ISP’S) attach to slab w/ 0.145" x 1 1/2” powder actuated fasteners spaced on 4” centers (HILTI DS 37 P10 or equal) -OR- (6) 3/8" DIA. 2205 expansion anchors w/ 2 1/2" min. embedment - OR-Simpson "Titen" screws @ 6" o.c."'
print(ExampleText)编码头行是必需的,因为其中有非ascii字符。
还可以用'''或"""包装文字。
x = '''some string'''
x = """some string"""注意,更好的解决方案可能是直接从数据中获取字符串,而不是使用像csv这样的包将其复制/粘贴到代码中。
https://stackoverflow.com/questions/29023097
复制相似问题