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
Solved! Go to Solution.
@umairah — Can you attach your file for input and desired output, both?
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 |
Regex_replace([text],"[^ -~]",'')
cheers,
mark