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

remove ascii characters and dots

Hi,

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

characters remove.PNG

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

Regards,

Umairah

Regex

Parse

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

cheers,

mark

@umairah — Try this solution:

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

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

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

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

cheers,

mark