VB 读取分隔字符串数据问题

有一字符串如:user:name%name%name%name.....%#type
name为不固定长度的字符串,以%为分隔,如何将name字符串一个一个读出,并写入到数据库USER表中的user字段?
求思路或原码,最好有代码.完成后正确再加分
最新回答
距离感

2025-06-27 04:19:39

用split函数可以把分隔符之间的值放到数组中:
r="name%name%name%name"
a=split(r,"%")
野稚

2025-06-27 05:36:12

conn为数据库连接
dim arry() as string
dim sql as string
dim i as integer

arry = split(user,"%")

for i = 0 to ubound(arry)
sql = "insert into user(user) values('" & arry(i) & "')"
conn.execute sql
next
暮雨醉花

2025-06-27 01:13:43

r="name%name%name%name"
a=split(r,"%")
for i=0 to ubound(A)
Print A(I)
Next