Need function condition to exclude any character other than numbers and alphabets for address in BI

Summary:

Need function condition to exclude any character other than numbers and alphabets for address in BI

Content (required):

Address should not have any characters other than numbers & alphabets - strip off any characters other than number and alphabets and replace them with space

Version (include the version you are using, if applicable):

22D

Code Snippet (add any code snippets that support your topic, if applicable):