remove ascii characters and dots

[umairah]

Hi,

I want to remove these ascii characters and the dots from the data. Is there a way?

Sample data will be attached upon request. Really appreciate the help.

Regards,

Umairah 

[vizAlter]

@umairah — Can you attach your file for input and desired output, both?

[umairah]

Hi @vizAlter ,

I will attached the sample data for you to review. The desired output that I want is all the ascii and dots to be remove such as below:

1.2.2

Rule of law 3.5.7 85

88

1.2.3 Cost of redundancy dismissal, salary weeks 20.8 5.2 Innovation linkages

5.2.1 University/Industry research collaboration 38.8 73

State of cluster development

[MarqueeCrew · Accepted solution]

Regex_replace([text],"[^ -~]",'')

 cheers,

 mark

[vizAlter · Accepted solution]

@umairah — Try this solution:

[umairah]

Hi @MarqueeCrew ,

Thank you, it worked.

Regards,

Umairah

[umairah]

Hi @vizAlter ,

I test the formula and it work as well. Thank you.

regards,

Umairah