7,763
社区成员
发帖
与我相关
我的任务
分享字符串查找的问题
isnull(@qtyField10am1,0) as 'Qty10am1',isnull(@qtyField11am1,0)
我想在上面的字符串上查找出是否有'as'这个字符怎么做.
我想在上面的字符串上查找出是否有'as'这个字符怎么做.
...全文
请发表友善的回复…
发表回复
northwolves 2003-09-09
- 打赏
- 举报
这样更简单：
Private Sub Command1_Click()
On Error Resume Next
MsgBox Split("isnull(@qtyField10am1,0) as 'Qty10am1',isnull(@qtyField11am1,0) ", "as")(1)
End Sub
Private Sub Command1_Click()
On Error Resume Next
MsgBox Split("isnull(@qtyField10am1,0) as 'Qty10am1',isnull(@qtyField11am1,0) ", "as")(1)
End Sub
of123 2003-09-09
- 打赏
- 举报
dim p as integer
dim x as string
dim strFound as string
x = "isnull(@qtyField10am1,0) as 'Qty10am1',isnull(@qtyField11am1,0)"
p = instr(1, x,"as")
if p then
strFound = mid(x, p + 1)
p = instr(1, strFound, "'")
strFound = mid(strFound, p + 1)
p = instr(1, strFound, "'")
strfound = left(strFound, p - 1)
else
strFound = ""
end if
dim x as string
dim strFound as string
x = "isnull(@qtyField10am1,0) as 'Qty10am1',isnull(@qtyField11am1,0)"
p = instr(1, x,"as")
if p then
strFound = mid(x, p + 1)
p = instr(1, strFound, "'")
strFound = mid(strFound, p + 1)
p = instr(1, strFound, "'")
strfound = left(strFound, p - 1)
else
strFound = ""
end if
sunjian5188 2003-09-09
- 打赏
- 举报
ok我知道了
haipingma 2003-09-09
- 打赏
- 举报
mid(x,isntr(x,"as")+1)
sunjian5188 2003-09-09
- 打赏
- 举报
那我要是想要找'as' 后面的字符那!
就是当条件满足时,就是这个字符串中有'AS' 的时候我要取他后面的字符串怎么办,谢谢先
就是当条件满足时,就是这个字符串中有'AS' 的时候我要取他后面的字符串怎么办,谢谢先
MSSQL 2003-09-09
- 打赏
- 举报
同意楼上的.
instr(x,"as")的返回值就是"as"在该字符串的位置.
instr(x,"as")的返回值就是"as"在该字符串的位置.
northwolves 2003-09-09
- 打赏
- 举报
x="isnull(@qtyField10am1,0) as 'Qty10am1',isnull(@qtyField11am1,0) "
instr(x,"as")>0 则有
instr(x,"as")>0 则有
