将字符串
CREATE TABLE "SCOTT"."TEST01" ("ID" NUMBER(*,0), "NAME" VARCHAR2(15) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS"
中的NUMBER(*,0)替换为NUMBER(10)改怎么替换呢,请大神赐教呀
楼下说的对,这里疏忽,把所有字符都匹配了。
result = re.sub('NUMBER(.*)', 'NUMBER(10)', 'aaa NUMBER(*,0) bbb')
这里再提供一种满足题主问题的方式吧:
result = re.sub('NUMBER([^)]*)', 'NUMBER(10', 'aaa NUMBER(*,0) bbb')
反对楼上
import re print(re.sub('NUMBER\(.*\)', 'NUMBER(10)', 'aaa NUMBER(*,0) bbb'))