How to Removing Special Characters in URLs
In Bold Reports, we offer a powerful solution for handling URL special characters through our code modules. These modules enable users to effortlessly decode URLs, removing special characters such as %20, %22, %E2, and more, ultimately resulting in accurate and user-friendly URLs. URLs often include these special characters, which can complicate their interpretation and usability. Bold Reports simplifies this issue by providing a straightforward method for users to decode and display URLs without these special characters, greatly enhancing the overall user experience.
To decode a URL in Bold Reports, follow these steps:
Drag and drop a text box into your report and include the URL content along with any special characters.
Click the grey area and add the following VB Code in code modules and then click OK.
Public Function Remove(ByVal input As String) As String input = input.Replace("%20", " ") input = input.Replace("%22", "") input = input.Replace("%E2", "") input = input.Replace("%80", "") input = input.Replace("%9C", "") input = input.Replace("%9D", "") input = input.Replace("%2C", ",") input = input.Replace("%2F", "/") Return input End Function
- Now set the expression for the text box as follows:
- Save and preview the report. The special characters in the URL will be removed and displaying only the URL.