Dropdownlist

[devlin]

Hi all.

I have a dropdownlist that has the usernames of people that I am getting from a sql table. However I must now only get the text after the / character in the username. Not sure on how to go aobut this. Could I possibly use SUBSTRING? Usernames are not all equal lengths.

Any help would be greatly appreciated
Thank you

[DrBunchman]

Hi devlin,

Here's a little code snippet which will get all the text after a certain character (assumes you have a recordset object called rs):

Dim sUsername 
Dim sCol = rs("ColumnName"), 
If Instr(sCol, "/") > 0 Then
     sUsername = Split(sCol , "/")(1)
End If
 

Do you know how the split function works? It creates an array from a string using a specified character as a delimiter. In this instance it splits the username from the database into two strings using the "/" as the dividing point and assigns the second item (which will be everything after the "/") to the variable sUsername.

Does this make sense? Let me know how you get on.

Dr B

PS you are using Classic ASP aren't you? If you're using .NET then let me know because the code will be slightly different.

[devlin]

Hi devlin,

Here's a little code snippet which will get all the text after a certain character (assumes you have a recordset object called rs):

Dim sUsername 
Dim sCol = rs("ColumnName"), 
If Instr(sCol, "/") > 0 Then
     sUsername = Split(sCol , "/")(1)
End If
 

Do you know how the split function works? It creates an array from a string using a specified character as a delimiter. In this instance it splits the username from the database into two strings using the "/" as the dividing point and assigns the second item (which will be everything after the "/") to the variable sUsername.

Does this make sense? Let me know how you get on.

Dr B

PS you are using Classic ASP aren't you? If you're using .NET then let me know because the code will be slightly different.

Hi, Thank you for the quick reply.
I got it sorted out about 15 minutes before I saw your reply.
Now for the hectic stuff!
Thanks

[DrBunchman]

Good work! Glad you got it sorted by yourself.

Dr B

[devlin]

Good work! Glad you got it sorted by yourself.

Dr B

Just one little thing I have to add... If I need to display the usernames alphabetically in the ddl... How would i do that in my code? As i cant SORT BY in my stored procedure because It will return them in alphabetical order but I am Using SUBSTRING to leave out the text until the / in the string. and it will bring them back alphabetically before I use substring and will not show them correctly.

Any ideas or advice?

Thank you

[devlin]

Hopefully that made sense.....

[DrBunchman]

You could store the usernames in an array and then sort that. If you're using .NET this will be easy enough using the Sort method.

If you're using Classic ASP then the following link contains a useful sort script.

http://snippets.dzone.com/posts/show/3233

Hope this helps,

Dr B