This topic is locked

Lookup wizard trailing commas

10/25/2005 13:18:31
ASPRunnerPro General questions
author

I use a lookup wizard to populate a field. Users can make multiple selections. I would like to replace the trailing commas with ">>" to indicate that the item has traveled from one department to another.
The result is now "Policy, Committee, Floor"
I would like it to appear as "Policy >> Committee >> Floor"
Is it possible to drop the comma or replace it with >>?
I've tried editing the variable and aspfunctions pages, but can't seem to find the code that needs changing.
Any suggestions?

Sergey Kornilov admin 10/26/2005

When you select multiple values from the list box web browser add commas between values automatically to pass multiple values to the database.
You can modify the way this filed value appears on List/View pages if you replace commas with ">>" write before displaying this field.

Response.Write Replace(strValue, ",", " >> ")