Remove a specific character from field.

Odd request here, but does anyone have any ideas around removing a specific character from a field?

Example: Account Name is “Client Name #23”. That is the client’s name add feeds a lot of systems that rely on it being consistent, so I can’t just change it to Client Name 23, but I need the # to not be in the field when I use it in a specific skuid page.

The reason for not needing it in the specific skuid page is because that page uses the Account Name in a URL and when it loads into the URL with the # it breaks the URL. 

Any suggestions on how I may override that field to specially remove a certain character like that?

Thanks!

Can you use the URL encode functionality?

https://community.skuid.com/t/redirect-to-url-with-url-encoding-for-special-characters

That worked perfectly. Thank you!