dim arr() as string arr=split(str,",") dim i as integer str="'" for i=0 ubound(arr)-1 str=str & arr(i) & "','" next str=str & arr(ubound(arr))没测试过,大概就是这个意思
Dim tmp() As String Str1 = "aaa,bbb,ccc,ddd" tmp = Split(Str1, ",") For i = 0 To UBound(tmp) tmp(i) = "'" & tmp(i) & "'" Next i Str1 = Join(tmp, ",") & ","
Function GetStr(s As String) As String Dim a a = Split(s, ",") GetStr = "'" & Join(a, "','") & "'" End FunctionPrivate Sub Command1_Click() Debug.Print GetStr("aaa,bbb,ccc,ddd") End Sub
str = "aaa,bbb,ccc,ddd"
如何实现字符串转化成
str = "'aaa','bbb','ccc','ddd’”
谢谢各位指教!
dim arr() as string
arr=split(str,",")
dim i as integer
str="'"
for i=0 ubound(arr)-1
str=str & arr(i) & "','"
next
str=str & arr(ubound(arr))没测试过,大概就是这个意思
你就在我刚才的基础上 str=str & arr(ubound(arr)) & ","
还有个招儿更简单
str=replace(str,",","','")
str="'" & str & "'"
Dim tmp() As String
Str1 = "aaa,bbb,ccc,ddd"
tmp = Split(Str1, ",")
For i = 0 To UBound(tmp)
tmp(i) = "'" & tmp(i) & "'"
Next i
Str1 = Join(tmp, ",") & ","
Function GetStr(s As String) As String
Dim a
a = Split(s, ",")
GetStr = "'" & Join(a, "','") & "'"
End FunctionPrivate Sub Command1_Click()
Debug.Print GetStr("aaa,bbb,ccc,ddd")
End Sub