Link representation problem when data includes a comma

[#1]

We're using a Link Representation expression field to launch a PDF based on CustomerName & InvoiceNo from a specified folder. It seems to be working for all customers except for those who have a comma in their company name, in which case the URL shows "%2C" in place of the comma. Any recommendations for coding around this?

[Oleg_Troyansky]

You'll need to use several "replace" functions to eliminate commas, spaces and other special characters, that don't work in the URL syntax.

[#3]

Where would you use those?  I also have an URL that I would like to open, but it has three commas in the syntax.

I can correctly show the link in the chart that will open it, and I can display the link as a expression by representing in as a hyperlink, not as a text field, but how do I intercept the URL function? 

QV can open the correct URL when I call the URL from a button, but not from an expression.