split string

[Guest_imported]

hi all,

i am a newbie to asp and i have given a project with a very short time period.

i have a text box where a user can enter a keywords seperated by comma for search.
i am comparing this keywords with a value in database.
now in order to do that i have to split the keyword string on comma.
can someone tell me how to do that? a code will be great because i am struggling with the syntax.

thanks in advance

new_to_asp

 

[gsc1ugs]

temp="gfdddfg,jgfhfgf"

str = instr(1,temp,",",1)
Response.Write str


This will basically give you 8 using the textual comparison.. u could use if instr(blabla) <> 0 then whatever you are doing with recordsets, something slike

if instr(1,Request.form(&quot;youtextfield&quot;,rs.Field(&quot;columnname&quot,1 ) <> 0 then

ok
else
Error
End if

Tick as usefull if happy Regards gsc1ugs
&quot;Cant see wood for tree's...!&quot;

 

[Discord]

wouldn't you want something like
MyString = &quot;123,456,789&quot;
MyArray = Split(MyString, &quot;,&quot?
result:
MyArray(0) = &quot;123&quot;
MyArray(1) = &quot;456&quot;
MyArray(2) = &quot;789&quot;

 

[Guest_imported]

thanks for the help guys

Howevere i dont know how many keywords the user will enter

so i did it like this

key = split(str,&quot;,&quot

for i=0 to ubound(key)
response.write(key(i))
next