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!