参数值里边的“_”替换为“.”

pingrac

目的是要把DRAWINGNO参数值里边的“_”替换为“.”。哪位大神有办法把if语句循环执行多次
DRAWINGNO=REL_MODEL_NAME
oritext = "_"
if search(DRAWINGNO,oritext)>1
tmp=extract(DRAWINGNO,1,search(DRAWINGNO,oritext)-1)
DRAWINGNO=tmp+"." + extract(DRAWINGNO,search(DRAWINGNO,oritext)+1,String_length(DRAWINGNO)-search(DRAWINGNO,oritext))
endif

a70332758

外行说一句，应该是加上else，然后继续search，然后没有_,就endif。

jiangjun21e

搬运一位大神的关系式，希望能帮到你
part_no=REL_MODEL_NAME
ORITEXT = "_"
IF SEARCH(part_no,ORITEXT)>1
TMP=EXTRACT(part_no,1,SEARCH(part_no,ORITEXT).1)
part_no=TMP+"." +  EXTRACT(part_no,SEARCH(part_no,ORITEXT)+1,STRING_LENGTH(part_no)\.SEARCH(part_no,ORITEXT))
ENDIF
IF SEARCH(part_no,ORITEXT)>1
TMP=EXTRACT(part_no,1,SEARCH(part_no,ORITEXT).1)
part_no=TMP + "." +  EXTRACT(part_no,SEARCH(part_no,ORITEXT)+1,STRING_LENGTH(\part_no).SEARCH(part_no,ORITEXT))
ENDIF
IF SEARCH(part_no,ORITEXT)>1
TMP=EXTRACT(part_no,1,SEARCH(part_no,ORITEXT).1)
part_no=TMP + "."+  EXTRACT(part_no,SEARCH(part_no,ORITEXT)+1,STRING_LENGTH(\part_no).SEARCH(part_no,ORITEXT))
ENDIF
IF SEARCH(part_no,ORITEXT)>1
TMP=EXTRACT(part_no,1,SEARCH(part_no,ORITEXT).1)
part_no=TMP + "." +  EXTRACT(part_no,SEARCH(part_no,ORITEXT)+1,STRING_LENGTH(\part_no).SEARCH(part_no,ORITEXT))
ENDIF
IF SEARCH(part_no,ORITEXT)>1
TMP=EXTRACT(part_no,1,SEARCH(part_no,ORITEXT).1)
part_no=TMP + "."+  EXTRACT(part_no,SEARCH(part_no,ORITEXT)+1,STRING_LENGTH(\part_no).SEARCH(part_no,ORITEXT))
ENDIF
IF SEARCH(part_no,ORITEXT)>1
TMP=EXTRACT(part_no,1,SEARCH(part_no,ORITEXT).1)
part_no=TMP + "." +  EXTRACT(part_no,SEARCH(part_no,ORITEXT)+1,STRING_LENGTH(\part_no).SEARCH(part_no,ORITEXT))
ENDIF

jiangjun21e

jiangjun21e 发表于 2021-6-24 09:09
搬运一位大神的关系式，希望能帮到你
part_no=REL_MODEL_NAME
ORITEXT = "_"

part_no为自定义参数

qq202777898

jiangjun21e 发表于 2021-6-24 09:09
搬运一位大神的关系式，希望能帮到你
part_no=REL_MODEL_NAME
ORITEXT = "_"

弱弱的问大佬一句这些表示啥意思

pingrac

jiangjun21e 发表于 2021-6-24 09:10
part_no为自定义参数

en 谢谢，也是这么弄的，复制粘贴五六次。。最笨的方法，见效快

lilj2002

参数：

CODE 字符串
NAME 字符串
NAME1 字符串
NAME2 字符串
TOTAL 整数
LOCA1 整数
斜杠 字符串 /
点 字符串

/*极限8个点
code=REL_MODEL_NAME()
total=string_length(code)
loca1=search(code,"--")
if loca1==0
name=code
else
name1=extract(code,1,loca1-1)
name2=extract(code,loca1+2,total-loca1-1)
name=name1+斜杠+name2
endif
total=string_length(name)
/*判断_存在
loca1=search(name,"_")
if loca1==0
else
name1=extract(name,1,loca1-1)
name2=extract(name,loca1+1,total-loca1)
name=name1+点+name2
endif
/*完
loca1=search(name,"_")
if loca1==0
else
name1=extract(name,1,loca1-1)
name2=extract(name,loca1+1,total-loca1)
name=name1+点+name2
endif
loca1=search(name,"_")
if loca1==0
else
name1=extract(name,1,loca1-1)
name2=extract(name,loca1+1,total-loca1)
name=name1+点+name2
endif
loca1=search(name,"_")
if loca1==0
else
name1=extract(name,1,loca1-1)
name2=extract(name,loca1+1,total-loca1)
name=name1+点+name2
endif
loca1=search(name,"_")
if loca1==0
else
name1=extract(name,1,loca1-1)
name2=extract(name,loca1+1,total-loca1)
name=name1+点+name2
endif
loca1=search(name,"_")
if loca1==0
else
name1=extract(name,1,loca1-1)
name2=extract(name,loca1+1,total-loca1)
name=name1+点+name2
endif
loca1=search(name,"_")
if loca1==0
else
name1=extract(name,1,loca1-1)
name2=extract(name,loca1+1,total-loca1)
name=name1+点+name2
endif
loca1=search(name,"_")
if loca1==0
else
name1=extract(name,1,loca1-1)
name2=extract(name,loca1+1,total-loca1)
name=name1+点+name2
endif

DRAW_NO=name

-----------------------------------------------------------
自己做的,希望有点帮助
曾加了个--转/

aku2005

jiangjun21e 发表于 2021-6-24 09:09
搬运一位大神的关系式，希望能帮到你
part_no=REL_MODEL_NAME
ORITEXT = "_"

这个关系设置的真好！