Link to home
Start Free TrialLog in
Avatar of Jon DeVito
Jon DeVito

asked on

ASP Replace function syntax

Can anyone help me fix this? Thanks!

AdminMultipleDate__MMColParam = "'" + String(Request.QueryString("UserName2")) + "'";
Test = Replace (AdminMultipleDate__MMColParam, ",", "', '");
---------------------------------------------

AdminMultipleDate__MMColParam returns the value: 'User1, User2, User3, User4'
I need Test to return the value: 'User1', 'User2', 'User3', 'User4'
Avatar of stefanx
stefanx

How About:

A = Split(Request.QueryString("UserName2"))
Test = ""
For X = 0 To UBound(A)
  If Len(Test) > 0 Then Test = Test & ", "
  Test = Test & "'" & A(X) & "'"
Next
Sorry, that's:

A = Split(Request.QueryString("UserName2"),",")
Test = ""
For X = 0 To UBound(A)
  If Len(Test) > 0 Then Test = Test & ", "
  Test = Test & "'" & A(X) & "'"
Next
Avatar of Jon DeVito

ASKER

Like this?

AdminMultipleDate__MMColParam = "'" + String(Request.QueryString("UserName2")) + "'";
 
var Test = ""
For X = 0 To UBound(AdminMultipleDate__MMColParam)
  If Len(Test) > 0 Then Test = Test & ", "
  Test = Test & "'" & AdminMultipleDate__MMColParam(X) & "'"
Next
I get an error on the X in For X.
ASKER CERTIFIED SOLUTION
Avatar of rg20
rg20
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks!!!