Report Text Module - Adding a '25' after every '%' symbol in my dynamic url

[rcrowejr1]

Hi - 

I am formatting a dynamic URL for one of my reports and am using the Report Text Module.  The URL is dynamic is very long however the dynamic portion works fine, but the part of the url that is hard-coded comes out of the process formatted incorrectly.  There are at least 3 % symbols in the hardcoded part of the URL and the module is adding a '25' after every %, which is causing a broken link on my final output when we try to access the hyperlink.  

I did a quick search of the community and didn't find anything to fix this 

Can anyone assist?

Thanks!

[MichalM]

@rcrowejr1 

How do you output the data? Would you be able to share the workflow?

[rcrowejr1]

Thanks for responding attached are some screenshots:

[MichalM]

Do you render the output as HTML? Any chance you can share with me the pcxml you're using in the Report Text? 

[rcrowejr1]

The output is ultimately in excel.  here is what I am doing in the render tool

However I am pretty sure the issue is in the Report Text b/c that's where the extra characters are being added

[MichalM]

@rcrowejr1 

I haven't been able to replicate the behaviour but I'd attribute it to URL encoding where some characters such as a spaces or % are converted to format that can be transmitted via the Internet. You can still get this corrected in Alteryx if it's not desired.

If you connect a Browse module right after your Text / Table module and select Cell Viewer within your Results, you will see that the content is just text formatted as pcxml.

It means that you can feed the field into the Formula module and use the Replace function to remove the bits you don't need

Replace([Table], "%25", "%")

The only challenge remaining is that the Render module may not recognise the updated field as a Report field and as a result there will be no valid fields to choose from in the Date Field drop-down

To work around this

• connect the Render module to the Table and configure it
• Enable XML in Properties window under Options > User Settings > Edit User Settings > Advanced 

• Navigate to the XML view within the configuration panel of the Render module and copy the XML

• Navigate to the Render module connected to the Formula, select the XML view, click the Edit button and paste the XML from the clipboard 

And this is the result

[rcrowejr1]

Thanks so much I will give that a try and let you know!

[rcrowejr1]

Thanks again I appreciate the assistance but still no go....I had added a formula module yesterday to remove the unwanted characters, but even after I tried your solution I can't get it to move to a hyperlink format until I run it through the Report Text Module which just puts the unwanted characters back in.  I will keep looking at it on my end.

[Grazvydas7]

Hello,

I faced the same issue, did you rcrwejr1 find a solution at the end?