Hello,

I have link in a column. This link has lot of sblank spaces in it. The link works fine in the PDF and HTML output format of the report whereas it does not work properly in the excel sheet. I have replaced all these spaces with an underscore and now I want to replace these underscores with "%20". I know we can replace one character with another but not one character with a string.
Can somebody guide me.

This message has been edited. Last edited by: <Emily McAllister>,

quote:

I know we can replace one character with another but not one character with a string.

Really? Have you read the help file on STRREP?

T

Yes I read the article for STRREP but it says only one character will be replaced. In the example given for the STRREP they have replaced a special character $ with USD. But in my case I have to replace blank spaces with "%20" which is a combination of special character and alphabets.

This message has been edited. Last edited by: Prajakta,

It's a combination of printable ASCII characters. There's nothing special about them. STRREP will do what you need.

It's easy to prove with a simple test case:

-SET &SAMPLE = 'STRREP will replace spaces with %20';
-SET &REPLACED = STRREP(40, &SAMPLE, 1, ' ', 3, '%20', 50, 'A50');

-TYPE "&SAMPLE" was replaced by "&REPLACED"

This message has been edited. Last edited by: Wep5622,

quote:

But in my case I have to replace blank spaces with "%20" which is a combination of special character and alphabets.

Did you try it though?

STRREP is a string replacement Function and "%20" is just a string.

T

Your example works perfectly fine but don't know why it is not working in my link with the same syntax.
I tried the same thing for Google link and it worked fine.

Solving that requires that we see both the statement that you used, the input that's causing problems and the error message you got.

My first guess is that the resulting URL didn't work for you because you replaced an underscore with %20 that was already an underscore before you replaced spaces with underscores. That would result in an HTTP 404 or similar.