python如何在指定字符串位置插入字符串

Question

我的代码如下：

<-[r4:hasSimpleCapability]-(g:Devices) where g.reach >= 100 g.payload >= 100 g.repeatability >= 0.1
RETURN DISTINCT g

如何自动插入 AND

<-[r4:hasSimpleCapability]-(g:Devices) where g.reach >= 100 AND g.payload >= 100 AND g.repeatability >= 0.1
RETURN DISTINCT g

Answer 1

有用记得采纳

# -*- coding: UTF-8 -*-
import re

sql = """<-[r4:hasSimpleCapability]-(g:Devices) where g.reach >= 100 g.payload >= 100 g.repeatability >= 0.1
RETURN DISTINCT g"""

replace_list = re.findall(r'g\..*? ', sql)
if len(replace_list) >= 2:
    for rep in replace_list[1:]:
        sql = sql.replace(rep, "AND " + rep)

print(sql)