Hi NG

Im tryinng to replace chars in a string in an url-action, to ensure that the
chars are URL encoded correctly. Replace doesnt work, what does?

example:
replace("http://localhost/mypage.aspx?arg="+[store].CurrentMember.UniqueName,
"&", "&")

but no, replace returns "http://???", not quite what i was hoping for
Any ideas?

- Kasper

This table indicates Replace() is not yet supported:

http://msdn.microsoft.com/library/de.../en-us/dnexcl2
k2/html/odc_xlsql.asp
...
Functions not supported in this release are marked by an asterisk in
this table.
...
*Replace

Here is a rather convoluted solution, borrowing both from sample VBA
code, and from earlier posts to this NG which used Calculated Cells for
MDX iteration:

'"http://localhost/mypage.aspx?arg= [store].&[1].&[2].&[3].&[4]"'

Member [Measures].[LeftReplace] as
'Left([Measures].[ReplaceURL],
InStr([Measures].[ReplaceURL], "&[") - 1)
+ "&amp"+ Right([Measures].[ReplaceURL],
Len([Measures].[ReplaceURL])
- InStr([Measures].[ReplaceURL], "&["))'

Cell Calculation [ReplaceAnd]
For '({[Measures].[ReplaceURL]})'
As 'iif(Instr(CalculationPassValue([Measures].[ReplaceURL], -1,
RELATIVE), "&[") = 0,
CalculationPassValue([Measures].[ReplaceURL], -1, RELATIVE),
CalculationPassValue([Measures].[LeftReplace], -1, RELATIVE))',
CALCULATION_PASS_DEPTH = 4,
CALCULATION_PASS_NUMBER = 5

select {[Measures].[ReplaceURL]} on columns
from Sales

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***