ASP中读取数据库内容时如何去掉空格,也就是
答案:6 悬赏:50 手机版
解决时间 2021-04-03 11:42
- 提问者网友:别再叽里呱啦
- 2021-04-02 22:35
ASP中读取数据库内容时如何去掉空格,也就是
最佳答案
- 五星知识达人网友:等灯
- 2021-04-02 22:46
<%=left(trim(rs("xx")),34)%> 去掉头尾空格
<%=left(Rtrim(rs("xx")),34)%> 去掉尾空格
<%=left(Ltrim(rs("xx")),34)%> 去掉头空格
<%=left(replace(rs("xx")," ","")),34)%> 去掉所有空格
<%=left(Rtrim(rs("xx")),34)%> 去掉尾空格
<%=left(Ltrim(rs("xx")),34)%> 去掉头空格
<%=left(replace(rs("xx")," ","")),34)%> 去掉所有空格
全部回答
- 1楼网友:拾荒鲤
- 2021-04-03 03:10
trim(rs("str"))这个是去掉头尾的空格。
- 2楼网友:拾荒鲤
- 2021-04-03 01:34
<%=left(trim(rs("xx")),34)%>
- 3楼网友:渡鹤影
- 2021-04-03 00:37
<%=left(trim(rs("xx")),34)%>
- 4楼网友:神的生死簿
- 2021-04-02 23:09
str = replace(str," ","")
- 5楼网友:持酒劝斜阳
- 2021-04-02 22:57
<%=nohtml(left(rs("xx"),34))%>
function nohtml(str)
if trim(str)<>"" then
dim re
Set re=new RegExp
re.IgnoreCase =true
re.Global=True
re.Pattern="(<.+?>)"
str=re.replace(str,"")
re.Pattern="(\<\/[^\<]*\>)"
str=re.replace(str," ")
str=replace(str," ","")
str = replace(str, " ", "")
str = Replace(str, CHR(32), "")
str = Replace(str, CHR(9), "")
str = Replace(str, CHR(34), "")
str = Replace(str, CHR(39), "")
str = Replace(str, CHR(13), "")
str = Replace(str, CHR(255), "")
str = Replace(str, CHR(10), "")
str = Replace(str, CHR(11), "")
str = Replace(str, CHR(12), "")
nohtml=str
set re=nothing
end if
end function
加上这个函数
function nohtml(str)
if trim(str)<>"" then
dim re
Set re=new RegExp
re.IgnoreCase =true
re.Global=True
re.Pattern="(<.+?>)"
str=re.replace(str,"")
re.Pattern="(\<\/[^\<]*\>)"
str=re.replace(str," ")
str=replace(str," ","")
str = replace(str, " ", "")
str = Replace(str, CHR(32), "")
str = Replace(str, CHR(9), "")
str = Replace(str, CHR(34), "")
str = Replace(str, CHR(39), "")
str = Replace(str, CHR(13), "")
str = Replace(str, CHR(255), "")
str = Replace(str, CHR(10), "")
str = Replace(str, CHR(11), "")
str = Replace(str, CHR(12), "")
nohtml=str
set re=nothing
end if
end function
加上这个函数
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯